RUBATO

Tables (6)

Untitled (RUBATO_Member)

  • Key (member_no) — NUMBER — Primary key — NOT NULL
  • Field (member_id) — VARCHAR2(40)
  • Field (member_pw) — VARCHAR2(200)
  • Field (member_nick) — VARCHAR2(40)
  • Field (member_gender) — VARCHAR2(2)
  • Field (member_birth) — DATE
  • Field (member_phone) — VARCHAR2(40)
  • Field (member_email) — VARCHAR2(100)
  • Field (member_joindate) — DATE

Untitled (RUBATO_Preference_category)

  • Key (Preference_category_no) — NUMBER — Primary key — NOT NULL
  • Field (Preference_category_name) — VARCHAR2(20)

Untitled (RUBATO_Preference)

  • Key (Preference_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (Preference_category_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (RUBATO_Board)

  • Key (free_board_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (free_board_title) — VARCHAR2(400)
  • Field (free_board_content) — VARCHAR2(4000)
  • Field (free_board_readcount) — NUMBER
  • Field (free_board_writedate) — DATE

Untitled (RUBATO_MailAuth)

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

Untitled (RUBATO_Board_Like)

  • Key (like_no) — NUMBER — Primary key — NOT NULL
  • Key (free_board_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (like_date) — DATE