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