snapshare

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

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

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_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