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)