Rubato

Tables (6)

Untitled (RB_member)

  • Key (member_no) — NUMBER — Primary key — NOT NULL
  • Field (member_id) — VARCHAR2(20) — NOT NULL
  • Field (member_pw) — VARCHAR2(120) — NOT NULL
  • Field (member_nick) — VARCHAR2(20) — NOT NULL
  • Field (member_gender) — VARCHAR2(4) — NOT NULL
  • Field (member_birth) — DATE — NOT NULL
  • Field (member_phone) — VARCHAR2(20) — NOT NULL
  • Field (member_email) — VARCHAR2(40) — NOT NULL
  • Field (member_joindate) — DATE — NOT NULL

Untitled (RB_Hobby_Category)

  • Key (category_no) — NUMBER — Primary key — NOT NULL
  • Field (category_name) — VARCHAR2(20) — NOT NULL

Untitled (RB_Hobby)

  • Key (hobby_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (category_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (RB_board)

  • Key (board_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (board_title) — NUMBER — NOT NULL
  • Field (board_comtent) — VARCHAR2(400) — NOT NULL
  • Field (board_readcount) — VARCHAR2(400) — NOT NULL
  • Field (board_writedate) — DATE — NOT NULL

Untitled (RB_Comment)

  • Key (comment_no) — NUMBER — Primary key — NOT NULL
  • Key (board_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (member_nick) — VARCHAR2(20) — NOT NULL
  • Field (comment_content) — VARCHAR2(400) — NOT NULL
  • Field (comment_writedate) — DATE — NOT NULL

Untitled (RB_like)

  • Key (like_no) — NUMBER — Primary key — NOT NULL
  • Key (board_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL