Duckhang2
Tables (10)
comment
- comment_id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key → post.post_id — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- content — TEXT — NOT NULL
event
- event_id — INT — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- category — VARCHAR(15) — NOT NULL
- description — TEXT — NOT NULL
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- location — VARCHAR(100) — NOT NULL
- latitude — DECIMAL(10,7) — NOT NULL
- longitude — DECIMAL(10,7) — NOT NULL
- creator_id — INT — Foreign key → user.user_id — NOT NULL
friend
- friend_id — INT — Primary key — NOT NULL
- status — ENUM('HOLD','ACCEPT') — NOT NULL
- requester_id — INT — Foreign key → user.user_id — NOT NULL
- receiver_id — INT — Foreign key → user.user_id — NOT NULL
imagecard
- card_id — INT — Primary key — NOT NULL
- visit_id — INT — Foreign key → visit.visit_id — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
partymember
- partymember_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- post_id — INT — Foreign key → post.post_id — NOT NULL
post
- post_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- event_id — INT — Foreign key → event.event_id — NOT NULL
- type — ENUM('NORMAL','PARTY') — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- max_people — INT
session
- session_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- refresh_token — VARCHAR(500) — NOT NULL
- issued_at — DATETIME — NOT NULL
- expired_at — DATETIME — NOT NULL
stamp
- stamp_id — INT — Primary key — NOT NULL
- visit_id — INT — Foreign key → visit.visit_id — NOT NULL
- stamp_name — VARCHAR(50) — NOT NULL
user
- user_id — INT — Primary key — NOT NULL
- google_id — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(15) — NOT NULL
- role — ENUM('USER','ADMIN') — NOT NULL
- level — INT — NOT NULL
- exp — INT — NOT NULL
visit
- visit_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- event_id — INT — Foreign key → event.event_id — NOT NULL
- visit_date — DATETIME — NOT NULL
- photo_url — VARCHAR(255) — NOT NULL
- gps_lat — DECIMAL(10,7) — NOT NULL
- gps_lng — DECIMAL(10,7) — NOT NULL
- gps_distance — DECIMAL(10,2)
- verification — ENUM('APPROVED','REJECTED') — NOT NULL