59
3.3.2 Data Dictionary
This contains the data dictionary of the system. It includes the field name,
field type, key and domain.
Table 1: INVENTORY
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
INV_CODE VARCHAR(15) YES PK This contains the
inventory code
INV_NAME VARCHAR(50) YES This contains the
inventory name
INV_STOCKS DECIMAL(10,2) YES This contains the
inventory stocks
INV_TYPE VARCHAR(20) YES This contains inventory
type
Table 2: INVENTORY DETAIL
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
INV_NO Varchar(15) YES PK This contains the
customer account ID
PRD_CODE Varchar(25) YES This contains the
customer first name
INV_CODE Varchar(25) YES This contains the
customer last name
INV_NAME Date YES This contains the
customer birthday
INV_STOCKS Varchar(14) YES This contains the
customer contact
number
INV_TYPE Varchar(40) YES This contains the
customer address
60
Table 3: RESERVATION
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
RES_NO INT(10) YES PK, FK This contains the
reservation number
PCK_CODE INT(10) YES FK This contains the
package cod This
contains the venue code e
VNE_CODE INT(10) YES FK This contains the venue
code
RES_PAX INT(10) YES This contains the
reservation pax
RES_CUST_FNAME VARCHAR(60) YES This contains the
reservation customer first
name
RES_CUST_LNAME VARCHAR(60) YES This contains the
reservation customer last
name
RES_CUS_MI VARCHAR(2) NO This contains the
reservation customer
middle initial
RES_CUS_EMAIL VARCHAR(80) NO This contains the
reservation customer
email
RES_CUST_MOBILE VARCHAR(60) YES This contains the
reservation customer
mobile number
RES_CUS_ADDR VARCHAR(45) YES This contains the date
Table 4: PACKAGE
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
PCK_CODE Varchar(13) YES PK This contains the
package code
PCK_NAME Varchar(45) YES This contains the
package name
PCK_PRICE DECIMAL(10,2) YES This contains the
package price
61
Table 5: PACKAGE DETAILED
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
PCKD_RECNO INT(10) YES PK This contains the
package detailed record
number
PCK_CODE VARCHAR(13) YES FK This contains the
package code
PRD_CAT_CODE VARCHAR(15) YES FK This contains the
product category code
PRD_CODE VARCHAR(13) YES FK This contains the
product code
PRD_CAT_NAME VARCHAR(50) YES FK This contains the
product category name
PRD_NAME VARCHAR(45) YES FK This contains the
product name
PCKD_LABEL VARCHAR(15) YES This contains the
package detail label
Table 6: TRANSACTION DETAILED
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
TRNS_NO INT(10) YES PK This contains the
transaction number
PRD_CODE VARCHAR(15) YES FK This contains the
product code
PRD_NAME VARCHAR(50) YES FK This contains the
product name
PRD_PRICE DECIMAL(10,2) YES FK This contains the
product price
TRNS_SUBTOTAL DECIMAL(10,2) YES This contains the
transaction number
TRNS_QTY INT(10) YES This contains the
transaction quantity
62
Table 7: TRANSACTION
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
TRNS_NO INT(10) YES PK This contains the
transaction number
TRNS_TOTAL DECIMAL(10,2) YES This contains the
AMOUNT transaction total amount
TRNS_PAYMENT DECIMAL(10,2) YES This contains the
transaction payment
TRNS_CHANGE DECIMAL(10,2) YES This contains the
transaction change
USERACC_NO VARCHAR(15) YES FK This contains the user
account number
USERACC_NAME VARCHAR(60) YES FK This contains the user
account name
USERACC_USER VARCHAR(30) YES FK This contains the user
TYPE account user type
TRNS_ORDERTYPE VARCHAR(30) YES This contains the
transaction order type
TRNS_DATE DATE YES This contains the
transaction date
TRNS_TIME TIME YES This contains the
transaction time
Table 8: VENUE
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
VNE_CODE INT(10) YES PK This contains the venue
code
VNE_NAME VARCHAR(60) YES This contains the venue
name
VNE_PRICE DECIMAL(10,2) YES This contains the venue
price
63
VNE_MAX_PAX INT(10) YES This contains the venue
maximum pax
VNE_DESC VARCHAR(50) NO This contains the venue
description
Table 9: PRODUCT CATEGORY
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
PRD_CAT_CODE VARCHAR(15) YES PK This contains the
product category code
PRD_CAT_NAME VARCHAR(45) YES This contains the
product category name
PRD_CAT_COLOR VARCHAR(20) YES This contains the
product category color
PRD_CAT_DESCRIPT VARCHAR(50) NO This contains the
ION product category
description
Table 10: PRODUCT
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
PRD_CODE VARCHAR(15) YES PK This contains
the product
code
PRD_CAT_CODE VARCHAR(15) YES FK This contains
the product
category code
PRD_NAME VARCHAR(50) YES This contains
the product
name
PRD_PRICE DECIMAL(10,2) YES This contains
the product
price
PRD_STATUS VARCHAR(20) YES This contains
the product
status
PRD_DESC VARCHAR(60) NO This contains
the product
description
64
PRD_IMAGE LONGBLOB NO This contains
the product
image
Table 11: CUSTOMER RESERVATION INFO
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
RES_NO INT(15) YES PK,FK This contains the
reservation number
CUS_USERNO INT(15) YES FK This contains the
customer user number
RES_CUST_FNAME VARCHAR(50) YES This contains the
reservation customer
firstname
RES_CUST_LNAME VARCHAR(50) YES This contains the
reservation customer
lastname
RES_CUST_MI VARCHAR(2) YES This contains the
reservation customer
middle initial
RES_CUST_BDATE DATE YES This contains the
reservation customer
email
RES_CUST_EMAIL VARCHAR(60) YES This contains the
reservation customer
email
RES_CUST_CONTAC VARCHAR(60) YES This contains the
T reservation customer
contact number
RES_CUST_HOUSEN VARCHAR(60) YES This contains the
O reservation house
number
RES_CUST_STREET VARCHAR(60) YES This contains the
reservation customer
street
RES_CUST_BRNGY VARCHAR(60) YES This contains the
reservation customer
barangay
RES_CUST_MUNICI VARCHAR(60) YES This contains the
PAL reservation customer
municipality
65
RES_CUST_PROVIN VARCHAR(60) YES This contains the
CE reservation customer
province
Table12: SETTINGS
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
POSSET_NO VARCHAR(13) YES PK This contains point of
sale setting number
POSSET_VAT FLOAT YES This contains point of
sale setting value
added tax
POSSET_SENIOR FLOAT YES This contains point of
sale setting senior
discount
POSSET_PWD FLOAT YES This contains point of
sale setting person
with disability
discount
POSSET_DELFEE FLOAT YES This contains point of
sale setting delivery
fee
POSSET_DELAMOUNT FLOAT YES This contains point of
sale setting delivery
amount
POSSET_MINIAMOUNT FLOAT YES This contains point of
ORDER sale setting minimum
amount order
66
Table 13: CUSTOMER USER_ACCOUNT
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
CUST_USERNO INT(10) YES PK This contains the
customer user number
CUST_FIRSTNAME VARCHAR(25) YES This contains the
customer first name
CUST_LASTNAME VARCHAR(25) YES This contains the
customer last name
CUST_BIRTHDATE DATE YES This contains the
customer birthdate
CUST_CONTACTNO INT(20) YES This contains the
customer contact
number
CUST_ADDRESS VARCHAR(45) YES This contains the
customer address
CUST_USERNAME VARCHAR(20) YES This contains the
customer username
CUST_PASSWORD VARCHAR(60) YES This contains the
customer password
Table 14: EDS CARD
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
EDS_CODE VARCHAR(15) YES PK This contains the eds
card code
TRNS_NO INT(10) YES FK This contains the
transaction number
EDS_TOTAL VALUE DECIMAL(10,2) YES This contains the eds
card total value
EDS_REDM_TOTAL INT(10) YES This contains the eds
card redeem total
67
Table 15: REWARD PRODUCT
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
REWPRD_CODE VARCHAR(15) YES PK This contains the
reward product code
EDS_CODE VARCHAR(15) YES FK This contains the eds
card code
REWPRD_NAME VARCHAR(50) YES This contains the
reward product name
RESWPRD_POINT DECIMAL(10,2) YES This contains the
reward product points
68
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
Res_No Varchar(15) YES PK This contains the
reservation number
Venue_Code Varchar(15) YES FK This contains the venue
code
CusAcc_ID Varchar(15) YES FK This contains the
customer account ID
Pck_Code Varchar(15) YES FK This contains the
package code
Cal_No Varchar(15) YES FK This contains the
calendar number
Res_Name Varchar(30) YES This contains the
reservation name
Res_Pax Int(3) YES This contains the
number of customer
Res_ContactNo Varchar(14) YES This contains the
customer contact
number
Res_Totalbill Decimal(10,2) YES This contains the
reservation total bill
Res_Payment Decimal(10,2) YES This contains the
reservation payment
69
Table 16: Reward Product
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
Rwd_Code Varchar(15) YES PK This contains the reward
code
Card_Barcode Varchar(15) YES FK This contains the
barcode
Rwd_Name Varchar(30) YES This contains the reward
name
Rwd_RedeemPoints Int(5) YES This contains the
redeem points of reward
Table 17: User Account
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
UserAcc_ID Varchar(15) YES PK This contains the user
account ID
UserAcc_Name Varchar(30) YES This contains the user
account name
UserAcc_UserName Varchar(25) YES This contains the user
account user name
UserAcc_Password Varchar(25) YES This contains the user
account password
UserAcc_Question Varchar(50) YES This contains the user
account question
UserAcc_Answer Varchar(50) YES This contains the user
account answer
70
Table 18: Venue
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
Venue_Code Varchar(15) YES PK This contains the venue
code
Venue_Name Varchar(30) YES This contains the venue
name
Venue_Price Decimal(10,2) YES This contains the venue
price
Venue_Description Varchar(50) YES This contains the venue
description
Venue_Image Long Blob This contains the venue
image
Table 18: Transaction
FIELD NAME FIELD TYPE REQUIRED KEY DOMAIN
Trans_No Varchar(15) YES PK This contains the
transaction number
Prd_Code Varchar(15) YES FK This contains the
product code
71
UserAcc_ID Varchar(15) YES FK This contains the user
ID
Card_Barcode Varchar(15) YES FK This contains the
barcode
Trans_Quantity Decimal(10,2) YES This contains the
transaction quantity
Trans_Subtotal Decimal(10,2) YES This contains the
transaction subtototal
Trans_Totalamount Decimal(10,2) YES This contains the
transaction total
amount
Trans_Date Date YES This contains the
transaction date
