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