SNAPSHARE2
Tables (6)
board
- board_id — number — Primary key — NOT NULL
- file_name — varchar2(255) — NOT NULL
- member_id — varchar2(50) — Foreign key → member.member_id — NOT NULL
- bookmark_count — number — NOT NULL
- reg_date — date
- hit_no — number
board_tag
- tag_id — number — Foreign key → tag.tag_id — NOT NULL
- board_id — number — Foreign key → board.board_id — NOT NULL
bookmark
- bookmark_id — number — Primary key — NOT NULL
- member_id — varchar2(50) — Foreign key → member.member_id — NOT NULL
- board_id — number — Foreign key → board.board_id — NOT NULL
member
- member_id — varchar2(50) — Primary key — NOT NULL
- password — varchar2(100) — NOT NULL
- email — varchar2(100) — NOT NULL
- name — varchar2(50) — NOT NULL
- role — varchar2(10)
reply
- reply_id — number — Primary key — NOT NULL
- board_id — number — Foreign key → board.board_id — NOT NULL
- member_id — varchar2(50) — Foreign key → member.member_id — NOT NULL
- reply_content — VARCHAR2(500) — NOT NULL
- reply_group — number(5,0) — NOT NULL
- reply_indent — number(5,0) — NOT NULL
- reply_order — number(5,0) — NOT NULL
tag
- tag_id — number — Primary key — NOT NULL
- tag_name — varchar2(50) — NOT NULL