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