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