STEPY
Tables (6)
ACCOMPANY_PLAN
- AC_COMPLANNUM — NUMBER — Primary key — NOT NULL
- M_ID (AC_ID) — NVARCHAR2(20 — Foreign key → MEMBER.M_ID — NOT NULL
- T_PLANNUM (AC_PLANNUM) — NUMBER — Foreign key → TRAVELPLAN.T_PLANNUM — NOT NULL
BLOG
- B_NUM — NUMBER(10) — Primary key — NOT NULL
- Field
CEO (ceo)
- C_NUM (c_num) — NVARCHAR2(10) — Primary key — NOT NULL
- C_PWD (c_pwd) — NVARCHAR2(100)
- C_EMAIL (c_email) — NVARCHAR2(30)
- C_JOIN (c_join) — NCHAR2(7)
- C_NAME (c_name) — NVARCHAR2(5)
- C_PHONE (c_phone) — NVARCHAR2(11)
MEMBER (member)
- M_ID (m_id) — NVARCHAR2(20 — Primary key — NOT NULL
- M_PWD (m_pwd) — NVARCHAR2(100)
- M_EMAIL (m_email) — NVARCHAR2(30)
STORE_REVIEW
- SR_COMMENT — NUMBER — Primary key — NOT NULL
- M_ID (SR_ID) — NVARCHAR2(20 — Foreign key → MEMBER.M_ID — NOT NULL
- C_NUM (SR_CNUM) — NVARCHAR2(10) — Foreign key → CEO.C_NUM — NOT NULL
- SR_RATE — NUMBER — MAXIMUN 5 MINIMUN0
- SR_WRITEDATE — DATE
- SR_CONTENTS — NVARCHAR2(800)
- SR_NUMOFREPORT — NUMBER
TRAVELPLAN
- T_PLANNUM — NUMBER — Primary key — NOT NULL
- T_SPOT — NVARCHAR2(20)
- T_BUDGET — NUMBER
- T_STDATE — DATE
- T_BKDATE (T_BKATE) — DATE