muan
Tables (3)
MENU (메뉴)
- MENU ID (menu_id) — INT — Primary key — NOT NULL
- USER ID (user_id) — VARCHAR2(100) — Foreign key → USER.USER ID — NOT NULL
- CATEGORY (category) — VARCHAR2(20)
- NAME (name) — VARCHAR2(100)
- PRICE (price) — VARCHAR2(100)
- DESCRIPTION (description) — VARCHAR2(4000)
- THUMBNAIL (thumbnail) — VARCHAR2(500)
- REG_DATE (reg_date) — DATE
- UPDATE_DATE (update_date) — DATE
- UPDATE_USER_ID (update_user_id) — VARCHAR2(100)
NOTICE (공지사항)
- NOTICE ID (notice_id) — INT — Primary key — NOT NULL
- USER ID (user_id) — VARCHAR2(100) — Foreign key → USER.USER ID — NOT NULL
- TITLE (title) — VARCHAR2(500)
- CONTENTS (contents) — CLOB
- REG_DATE (reg_date) — DATE
- UPDATE_DATE (update_date) — DATE
- UPDATE_USER_ID (update_user_id) — VARCHAR2(100)
- COUNTING (counting) — INT
USER (사용자)
- USER ID (user_id) — VARCHAR2(100) — Primary key — NOT NULL
- USER PW (user_pw) — VARCHAR2(100)
- REG DATE (reg_date) — DATE