wish erd

Tables (14)

Member

  • Key (member_no) — NUMBER — Primary key — NOT NULL
  • Field (member_id) — VARCHAR2(40)
  • Field (member_pw) — VARCHAR2(40)
  • Field (member_name) — VARCHAR2(40)
  • Field (member_phone) — VARCHAR2(40)
  • Field (member_email) — VARCHAR2(40)
  • Field (member_joindate) — DATE
  • Field

Untitled (Interest_Category)

  • Key (intercate_no) — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
  • Key (wish_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (wide_cate_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (MailAuth)

  • Key (mailauth_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
  • Field (mailauth_key) — VARCHAR2(200)
  • Field (mailauth_complete) — VARCHAR2(40)
  • Field (mailauth_date) — DATE

Untitled (Friends)

  • Key (friends_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
  • Field (friends_name)
  • Field

Untitled (Customer_Service)

  • Key (cs_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
  • Field (cs_question) — VARCHAR2(40)
  • Field (cs_answer) — VARCHAR2(40)

Untitled (Todo_)

  • Key (todo_no) — Primary key — NOT NULL
  • Key (wish_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (todo_title)
  • Field (todo_time)
  • Field (todo_list)
  • Field

Untitled (Comment)

  • Key — Primary key — NOT NULL
  • Key (todo_no) — Foreign key → Untitled.Key — NOT NULL
  • Key (wish_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (WishList)

  • Key (wish_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
  • Field (wish_title) — VARCHAR2(40)
  • Field (wish_dday) — DATE
  • Field (wish_content) — VARCHAR2(40)
  • Field (wish_readcount) — NUMBER
  • Field (wish_writedate) — DATE

Untitled (Ranking)

  • Key (rank_no) — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL

Untitled (BoardImage)

  • Key (image_no) — NUMBER — Primary key — NOT NULL
  • Key (board_no) — NUMBER — Foreign key → Untitled2.Key — NOT NULL
  • Field (image_link) — VARCHAR2(40)
  • Field (image_filename) — VARCHAR2(40)

Untitled (Board_Like)

  • Key (board_like_no) — NUMBER — Primary key — NOT NULL
  • Key (board_no) — NUMBER — Foreign key → Untitled2.Key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled2.Key — NOT NULL
  • Field (likedate) — DATE

Untitled (Wide_Category)

  • Key (wide_cate_no) — NUMBER — Primary key — NOT NULL
  • Field (wcate_name)

Untitled (Narrow_Cate)

  • Key (ncate_no) — NUMBER — Primary key — NOT NULL
  • Field

Untitled2 (Board)

  • Key (board_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
  • Field (board_title) — VARCHAR2(40)
  • Field (board_content) — VARCHAR2(40)
  • Field (board_writedate) — DATE
  • Field (board_readcount) — NUMBER