CafeShop

Tables (5)

CATEGORY (Untitled)

  • ID (Key) — Primary key — NOT NULL
  • NAME (Field2)
  • CREATE_DATE (Field3)
  • UPDATE_DATE (Field4)

DINNING_TABLE (Untitled3)

  • ID (Key) — Primary key — NOT NULL
  • DINNING_TABLE_NO (Field)
  • IS_MERGE_TABLE (Field2)
  • TABLE_IDS (TABLE.ID)

ITEM (Untitled2)

  • ID (Key) — Primary key — NOT NULL
  • CATEGORY_ID (CATEGORY.ID)
  • NAME (Field2)
  • CREATE_DATE (Field3)
  • UPDATE_DATE (Field4)
  • PRICE (Field)

ORDER (Untitled4)

  • ID (Key) — Primary key — NOT NULL
  • Field

TABLE (Untitled5)

  • ID (Key) — Primary key — NOT NULL
  • TABLE_NO (Field)
  • DESCRIPTION (Field2)
  • STATUS (0: avaliable; 1: not avaliable)
  • Field4
  • Field5