h7

Tables (4)

Exhibition (전시)

  • exhibition_id (전시번호) — INT
  • title (전시명) — VARCHAR(255)
  • location (전시장소) — VARCHAR(255)
  • start_date (시작일) — DATE
  • end_date (종료일) — DATE

Log (로그)

  • log_id (로그번호) — INT
  • user_id (유저번호) — INT — Foreign key → User.user_id
  • exhibition_id (전시번호) — INT — Foreign key → Exhibition.exhibition_id
  • content (전시후기) — TEXT
  • rating (평점) — DECIMAL(2,1)
  • created_at (작성일시) — DATETIME
  • updated_at (수정일시) — DATETIME

Photo (사진)

  • photo_id (사진번호) — INT
  • log_id (로그번호) — INT — Foreign key → Log.log_id
  • image_url (이미지경로) — VARCHAR(500)

User (유저)

  • user_id (유저번호) — INT
  • email (이메일) — VARCHAR(255)
  • password (비밀번호) — VARCHAR(255)
  • nickname (닉네임) — VARCHAR(50)