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