TBL_CUSTOMER_FOOD_ORDER_HEADER

Tables (4)

TBL_CUSTOMER_FOOD_ORDER_HEADER (주문내역)

  • ORDER_ID — VARCHAR — Foreign key → TBL_CUSTOMER_FOOD_ORDER_ITEM.ORDER_ID — NOT NULL
  • CUST_ID (Field) — VARCHAR(20)
  • REG_DATE — VARCHAR(20)
  • REG_TIME — VARCHAR(8)
  • UPT_DATE — VARCHAR(20)
  • UPT_TIME — VARCHAR(8)

TBL_CUSTOMER_FOOD_ORDER_ITEM (주문)

  • ORDER_ID — VARCHAR — Primary key — NOT NULL
  • FOOD_ID — VARCHAR — Foreign key → TBL_FOOD_INFO.FOOD_ID — NOT NULL
  • REG_DATE — VARCHAR(20)
  • REG_TIME — VARCHAR(8)
  • UPT_DATE — VARCHAR(20)
  • UPT_TIME — VARCHAR(8)
  • FOOD_CNT — int
  • PRICE — int

TBL_FOOD_INFO (음식메뉴)

  • FOOD_ID — VARCHAR — Primary key — NOT NULL
  • STORE_ID — VARCHAR — Foreign key → TBL_STORE_INFO.STORE_ID — NOT NULL
  • FOOD_NAME — VARCHAR(255)
  • REG_DATE — VARCHAR(20)
  • REG_TIME — VARCHAR(8)
  • UPT_DATE — VARCHAR(20)
  • UPT_TIME — VARCHAR(8)

TBL_STORE_INFO (음식코너)

  • STORE_ID — VARCHAR — Primary key — NOT NULL
  • STORE_NAME — VARCHAR(255)
  • REG_DATE — VARCHAR(20)
  • REG_TIME — VARCHAR(8)
  • UPT_DATE — VARCHAR(20)
  • UPT_TIME — VARCHAR(8)