ddd
Tables (3)
Bulletin board (board)
- number (board_no) — number — Primary key — NOT NULL
- Key (member_id) — varchar2(30) — Foreign key → mamber.Key — NOT NULL
- (board_title) — varchar2(300)
- Field2 (board_content) — varchar2(3000)
- Field4 (board_write_time) — date
- Field5 (board_count) — number
- Field6 (board_like) — number
- Field (board_hate) — number
Comments (board_comment)
- Key (board_comment_no) — number — Primary key — NOT NULL
- Key (member_id) — varchar2(30) — Foreign key → mamber.Key — NOT NULL
- number (board_no) — number — Foreign key → Bulletin board.number — NOT NULL
- Field (board_comment_content) — varchar2(1000)
- Field2 (board_comment_time) — date
- Field3 (board_comment_like) — number
- Field4 (board_comment_hate) — number
mamber (board_member)
- Key (member_id) — varchar2(30) — Primary key — NOT NULL
- Field (member_passwd) — char(128)
- Field2 (member_name) — varchar2(30)
- Field3 (member_nick) — varchar2(30)