HONG_DB

Tables (5)

CONTENT_TBL

  • ID (id2) — VARCHAR2(20) — Foreign key → MEMBER_TBL.ID — NOT NULL
  • NUM (num) — NUMBER
  • C_NAME (c_name) — NVARCHAR2(20)
  • TITLE (title) — NVARCHAR2(50)
  • CONTENT (content) — NVARCHAR2(250)

MEMBER_TBL

  • ID (id) — VARCHAR2(20) — Primary key — NOT NULL
  • PW (pw) — VARCHAR2(50)
  • NAME (name) — NVARCHAR2(20)
  • PHONE (phone) — VARCHAR2(20)
  • ADDRESS1 (address1) — NVARCHAR2(20)
  • ADDRESS2 (address2) — NVARCHAR2(50)

MENU_TBL (menu_TBL)

  • NUM (numn) — NUMBER — Primary key — NOT NULL
  • M_NAME (m_name) — NVARCHAR2(20)
  • PRICE (price) — NUMBER
  • M_SIZE (m_size) — NVARCHAR2(20)
  • M_CONTENT (m_content) — NVARCHAR2(250)
  • M_ID (m_id) — VARCHAR2(20)

ORDER_TBL (order_TBL)

  • NUM (numn) — NUMBER — Foreign key → MENU_TBL.NUM — NOT NULL
  • ID (id) — VARCHAR2(20) — Foreign key → MEMBER_TBL.ID — NOT NULL
  • O_MENU (o_menu) — NVARCHAR2(20)
  • o_price — NUMBER
  • O_SIZE (o_size) — NVARCHAR2(20)

WRITER_TBL (writer_TBL)

  • ID (id2) — VARCHAR2(20) — Foreign key → CONTENT_TBL.ID — NOT NULL
  • C_NAME (C__NAME) — NVARCHAR2(20)
  • CONTENT (content) — NVARCHAR2(250)
  • num — NUMBER