Semi

Tables (6)

BULLETIN (게시판)

  • ID (Key) — Primary key — NOT NULL
  • TAB_ID (Key2) — Foreign key → TAB.ID — NOT NULL
  • TITLE (Field) — NOT NULL
  • CONTENT (Field2) — NOT NULL
  • AUTHOR (Field3) — NOT NULL
  • REGDATE (Field4) — NOT NULL
  • COMMENT_ID (Field5)

CATEGORY (카테고리)

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

MENU (메뉴)

  • ID (Key) — Primary key — NOT NULL
  • CATEGORY_ID (Key2) — Foreign key → CATEGORY.ID — NOT NULL
  • NAME (Field) — NOT NULL
  • PRICE (Field2) — NOT NULL
  • TSALES (Field3)
  • IMG1 (Field4)
  • IMG2 (Field5)
  • IMG3 (Field6)

RECEIPT (영수증)

  • ID (Key) — Primary key — NOT NULL
  • TAB_ID (Key2) — Foreign key → TAB.ID — NOT NULL
  • REGDATE (Field) — NOT NULL
  • PAYMENT (Field2) — NOT NULL
  • TOTAL (Field3) — NOT NULL

SALES (판매목록)

  • ID (Key) — Primary key — NOT NULL
  • MENU_ID (Key2) — Foreign key → MENU.ID — NOT NULL
  • RECEIPT_ID (Key3) — Foreign key → RECEIPT.ID — NOT NULL
  • TAB_ID (Key4) — Foreign key → TAB.ID — NOT NULL
  • QT (Field)
  • S_SERVICE (Field2) — NOT NULL
  • S_PRICE (Field3) — NOT NULL

TAB (테이블)

  • ID (Key) — Primary key — NOT NULL
  • PWD (Field)
  • NAME (Field2)
  • ADMIN_ID (Field3)
  • NUM (Field4)