앨범
테이블 (6)
MEMBER
- REGISTER_ID — NUMBER — NOT NULL
- ID — VARCHAR(100)
- PASSWORD — VARCHAR(256)
- NAME — VARCHAR(100)
gallery_board
- board_id — NUMBER — NOT NULL
- member_id — NUMBER — NOT NULL
- title — VARCHAR2(50) — NOT NULL
- content — CLOB — NOT NULL
- view_cnt — NUMBER
- written_dt — DATE
- del_yn — VARCHAR2(1) — NOT NULL
gallery_file
- file_id — NUMBER — 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
gallery_like
- like_id — NUMBER — NOT NULL
- board_id — NUMBER — NOT NULL
- member_id — NUMBER — NOT NULL
gallery_tag
- tag_id — NUMBER — NOT NULL
- board_id — NUMBER — NOT NULL
- tag_name — VARCHAR2(50) — NOT NULL
gallery_view
- board_id — NUMBER — 기본 키 — NOT NULL
- member_id — NUMBER — 기본 키 — NOT NULL
- view_date — DATE — 기본 키 — NOT NULL