SmartCafe v0.1
Tables (9)
TBL_BRANCH
- ID — Primary key
- NAME
- BRANCH_MANAGER_ID
- IS_AVAILABLE
- OPEN_DATE
- CLOSE_DATE
- OPEN_TIME_OF_DAY
- CLOSE_TIME_OF_DAY
- ADDRESS
- WEBSITE_URL
- TEL_NO
- CREATED_USER
- UPDATED_USER
- CREATED_DATE
- UPDATED_DATE
TBL_COUPON
- COUPON_ID — Primary key — NOT NULL
- COUPON_NAME — NOT NULL
- COUPON_DISCOUNT — NOT NULL
- VALID_FROM
- VALID_TO
TBL_CUSTOMER
- CUSTOMER_ID — Primary key — NOT NULL
- CUSTOMER_NAME — NOT NULL
- PHONE
- ADDRESS1
- ADDRESS2
- CITY
- STATE
- POSTAL_CODE
TBL_EMPLOYEE
- EMPLOYEE_ID — Primary key — NOT NULL
- LAST_NAME
- FIRST_NAME
- PHONE_NO
- PHOTO
- ADDRESS
TBL_INVOICE
- INVOICE_NO — Primary key — NOT NULL
- ORDER_ID
- CUSTOMER_ID
- STAFF_ID
- ORDER_DATE
- INVOICE_DATE
- SHIP_ID
- SHIP_ADDRESS
- TOTAL_AMOUNT
- CURRENCY
TBL_ITEM
- ITEM_ID — Primary key — NOT NULL
- ITEM_NAME
- ITEM_NAME_EN
- ITEM_DESCRIPTION
- ITEM_SIZE
- CATEGORY_ID — NOT NULL
- QUANTITY_PER_UNIT
- UNIT_PRICE
- UNIT_IN_STOCK
- UNIT_ON_ORDER
- ITEM_IMAGE
- ITEM_IMAGE2
- ITEM_IMAGE3
TBL_ITEM_CATEGORY
- CATEGORY_ID — Primary key — NOT NULL
- CATEGORY_NAME
- CATEGORY_DESC
- CATEGORY_PICTURE
TBL_ORDER
- ORDER_ID — Primary key — NOT NULL
- CUSTOMER_ID — Primary key — NOT NULL
- STAFF_ID — Primary key — NOT NULL
- ORDER_DATE
- DELIVERY_DATE
- DELIVERY_TIME
- PAYMENT_METHOD
- ORDER_NOTES
- ORDER_STATUS — 0 - PENDING 1 - WAITING 2 - DELIVERED
- CREATED_USER
- UPDATE_USER
- CREATED_DATE
- UPDATED_DATE
TBL_ORDER_DETAILS
- ORDER_ID — Primary key — NOT NULL
- ITEM_ID — Primary key — NOT NULL
- UNIT_PRICE
- QUANTITY
- DISCOUNT