rubato

Tables (3)

Untitled (rubato_member)

  • Key (member_no) — number — Primary key — NOT NULL
  • Field (member_id) — varchar2(20) — NOT NULL
  • Field (member_pw) — varchar2(160) — 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 (rubato_board)

  • Key (board_no) — number — Primary key — NOT NULL
  • Key (member_no) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (board_title) — varchar2(400) — NOT NULL
  • Field (board_content) — varchar2(4000) — NOT NULL
  • Field (board_readcount) — number — NOT NULL
  • Field (board_writedate) — date — NOT NULL

Untitled (rubato_comment)

  • Key (comment_no) — number — Primary key — NOT NULL
  • Key (member_nick) — varchar2(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (board_no) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (comment_content) — varchar2(200) — NOT NULL
  • Field (comment_writedate) — number — NOT NULL