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)