artiste
Tables (10)
ART (전시작품)
- PK (art_id) — INT — Primary key — NOT NULL
- FK (exhibition_id) — INT — Foreign key → EXHIBITION.PK — NOT NULL
- 작품 (art_image) — VARCHAR(255) — NOT NULL
- 작품명 (art_name) — VARCHAR(50) — NOT NULL
- 작품설명 (art_desc) — VARCHAR(255) — NOT NULL
- 생성날짜 (created_date) — DATETIME — NOT NULL
- 마지막수정날짜 (modified_date) — DATETIME — NOT NULL
AUTHORITY (권한)
- PK (authority_name) — VARCHAR(50) — Primary key — NOT NULL
COMMENT (댓글)
- PK (comment_id) — INT — Primary key — NOT NULL
- FK (user_id) — INT — Foreign key → USER.PK — NOT NULL
- FK (exhibition_id) — INT — Foreign key → EXHIBITION.PK — NOT NULL
- 댓글 (comment_content) — VARCHAR(255) — NOT NULL
- 생성날짜 (created_date) — DATETIME — NOT NULL
- 마지막수정날짜 (modified_date) — DATETIME — NOT NULL
EXHIBITION (전시회)
- PK (exhibition_id) — INT — Primary key — NOT NULL
- FK (user_id) — INT — Foreign key → USER.PK — NOT NULL
- 전시회명 (exhibition_name) — VARCHAR(50) — NOT NULL
- 전시회시작 (exhibition_start_date) — DATETIME — NOT NULL
- 전시회마감 (exhibition_end_date) — DATETIME — NOT NULL
- 전시회설명 (exhibition_desc) — VARCHAR(255) — NOT NULL
- 생성날짜 (created_date) — DATETIME — NOT NULL
- 마지막수정날짜 (modified_date) — DATETIME — NOT NULL
- 승인상태 (exhibition_state) — ENUM("approval", "standby") — NOT NULL
EXHIBITION_TAG (전시타입)
- PK (exhibition_tag_id) — INT — Primary key — NOT NULL
- FK (exhibition_id) — INT — Foreign key → EXHIBITION.PK — NOT NULL
- 태그명 (exhibition_tag_name) — ENUM — NOT NULL
FOLLOW (팔로우)
- PK (follow_id) — INT — Primary key — NOT NULL
- FK (following) — INT — Foreign key → USER.PK — NOT NULL
- FK (follower) — INT — Foreign key → USER.PK — NOT NULL
QNA (문의사항)
- PK (qna_id) — INT — Primary key — NOT NULL
- FK (user_id) — INT — Foreign key → USER.PK — NOT NULL
- 문의사항 (qna_content) — VARCHAR(255) — NOT NULL
- 답변 (qna_answer) — VARCHAR(255)
- 답변여부 (qna_state) — BOOLEAN — NOT NULL
SCRAP (찜)
- PK (scrap_id) — INT — Primary key — NOT NULL
- FK (user_id) — INT — Foreign key → USER.PK — NOT NULL
- FK (exhibition_id) — INT — Foreign key → EXHIBITION.PK — NOT NULL
- 생성날짜 (created_date) — DATETIME — NOT NULL
- 마지막수정날짜 (modified_date) — DATETIME — NOT NULL
USER (회원)
- PK (user_id) — INT — Primary key — NOT NULL
- 이메일 (email) — VARCHAR(50) — NOT NULL
- 비밀번호 (password) — VARCHAR(50) — NOT NULL
- 이름 (username) — VARCHAR(50) — NOT NULL
- 생년월일 (birthday) — DATE — NOT NULL
- 성별 (gender) — INT — NOT NULL
- 활동상태 (activated) — BOOLEAN — NOT NULL
- 프로필이미지 (profile_image) — VARCHAR(255) — NOT NULL
- 생성날짜 (created_date) — DATETIME — NOT NULL
- 마지막수정날짜 (modified_date) — DATETIME — NOT NULL
USER_AUTHORITY (회원 권한)
- FK (user_id) — INT — Foreign key → USER.PK — NOT NULL