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