project

Tables (13)

categorys (카태고리)

  • (id) — Primary key — NOT NULL
  • (depth)
  • Field (name)
  • (id2) — Foreign key → categorys.id — NOT NULL

clubs (동호회 테이블)

  • Key (club_id) — Primary key — NOT NULL
  • (uid) — Foreign key → users.uid — NOT NULL
  • (id2) — Foreign key → categorys.id — NOT NULL
  • Field (name)
  • Feild (introduction)
  • Field (image)
  • Field (creator_id)
  • Field (member_limit)
  • Field (club_category_name)
  • Field (allow_guest)
  • Field (view_count)
  • Field (activity_type)
  • Field (local_station)
  • Field (wide_regions)

event (이벤트 테이블)

  • Key (id) — Primary key — NOT NULL
  • (uid) — Foreign key → users.uid — NOT NULL
  • Key (club_id2) — Foreign key → clubs.Key — NOT NULL
  • Field (club_id)
  • Field (title)
  • Field (content)
  • Field (start_date)
  • Field (end_date)
  • Field (location)
  • Field (guest_allow)
  • Field (max_participants)

hearts (라이크)

  • Key (like_id) — int — Primary key — NOT NULL
  • (uid) — Foreign key → users.uid — NOT NULL
  • Key (club_id) — Foreign key → clubs.Key — NOT NULL

locations (동호회 위치 테이블)

  • Key (club_id) — Primary key — NOT NULL
  • Key (club_id2) — Foreign key → clubs.Key — NOT NULL
  • (uid) — Foreign key → clubs.uid — NOT NULL
  • (id22) — Foreign key → clubs.id2 — NOT NULL
  • Field (point)
  • Field (poligon)

members (멤버 테이블)

  • Key (id) — Primary key — NOT NULL
  • Key (club_id) — Foreign key → clubs.Key — NOT NULL
  • (uid2) — Foreign key → clubs.uid — NOT NULL
  • (uid3) — Foreign key → users.uid — NOT NULL
  • (id2) — Foreign key → clubs.id2 — NOT NULL
  • Field (member_uid)
  • Field (signup_date)

participant (참여자)

  • Key (participant_id) — Primary key — NOT NULL
  • Key (id2) — Foreign key → event.Key — NOT NULL
  • (uid2) — Foreign key → users.uid — NOT NULL
  • Field (state)

points (포인트)

  • (user_id_fk) — Primary key — NOT NULL
  • (uid) — Foreign key → users.uid — NOT NULL

review (리뷰)

  • Key (id) — Primary key — NOT NULL
  • Key (club_id) — Foreign key → clubs.Key — NOT NULL
  • (uid2) — Foreign key → users.uid — NOT NULL
  • Field (content)
  • Field (star)
  • Field (affiliation)

tags (Untitled)

  • Key (id) — Primary key — NOT NULL
  • Key (club_id) — Foreign key → clubs.Key — NOT NULL
  • Field (tag)

userintrests (관심 키워드 테이블)

  • (uid) — Primary key — NOT NULL
  • (uid2) — Foreign key → users.uid — NOT NULL
  • Field (keyword_category_name)

users (유저 테이블)

  • (uid) — Primary key — NOT NULL
  • (kakao_id)
  • (kakao_name)
  • (kakao_profile_image)
  • (age)
  • (gender)
  • (introduction)
  • (location)

verifications (참여 인증 테이블)

  • (proof_eid) — Primary key — NOT NULL
  • Key (id2) — Foreign key → event.Key — NOT NULL
  • Field (image)