Semi_D
Tables (5)
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)
MENU (메뉴)
- ID (Key) — Primary key — NOT NULL
- NAME (Field) — NOT NULL
- PRICE (Field2) — NOT NULL
- TSALES (Field3)
- CATEGORY (Field4) — NOT NULL
- IMG1 (Field5)
- IMG2 (Field6)
- IMG3 (Field7)
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)