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