fsdfs

Tables (6)

MEMBER

  • REGISTER_ID — NUMBER(19) — Primary key — NOT NULL
  • ID — VARCHAR(100)
  • PASSWORD — VARCHAR(256)
  • NAME — VARCHAR(100)

gallery_board

  • board_id — NUMBER — Primary key — NOT NULL
  • title — VARCHAR2(50) — NOT NULL
  • content — CLOB — NOT NULL
  • view_cnt — NUMBER
  • written_dt — DATE
  • del_yn — VARCHAR2(1) — NOT NULL
  • member_id — NUMBER — NOT NULL
  • REGISTER_ID — NUMBER(19) — Foreign key → MEMBER.REGISTER_ID — NOT NULL

gallery_file

  • file_id — NUMBER — Primary key — NOT NULL
  • board_id — NUMBER — NOT NULL
  • original_file_name — VARCHAR2(255) — NOT NULL
  • stored_file_path — VARCHAR2(500) — NOT NULL
  • file_size — NUMBER — NOT NULL
  • download_cnt — NUMBER — NOT NULL
  • delete_yn — CHAR(1) — NOT NULL
  • create_dt — DATE — NOT NULL
  • thumb_yn — VARCHAR2(1) — NOT NULL
  • board_id (board_id2) — NUMBER — Foreign key → gallery_board.board_id — NOT NULL

gallery_like

  • like_id — NUMBER — Primary key — NOT NULL
  • board_id — NUMBER — NOT NULL
  • member_id — NUMBER — NOT NULL
  • board_id (board_id2) — NUMBER — Foreign key → gallery_board.board_id — NOT NULL

gallery_tag

  • tag_id — NUMBER — Primary key — NOT NULL
  • board_id — NUMBER — NOT NULL
  • tag_name — VARCHAR2(50) — NOT NULL
  • board_id (board_id2) — NUMBER — Foreign key → gallery_board.board_id — NOT NULL

gallery_view

  • board_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Primary key — NOT NULL
  • view_date — DATE — Primary key — NOT NULL
  • board_id (board_id2) — NUMBER — Foreign key → gallery_board.board_id — NOT NULL