FLAGIT
Tables (14)
ActivityLocation (회원이 활동한 장소)
- id (Key) — Primary key — NOT NULL
- Member_id (Key2) — Foreign key → Member.Member_id — NOT NULL
- id (Key3) — Foreign key → Location.id — NOT NULL
- Flag_id (Key22) — Foreign key → Location.Flag_id — NOT NULL
- Member_id (Key222) — Foreign key → Location.Member_id — NOT NULL
- visited_name (Field2)
- comments (Field4)
- date (Field5)
- visited_lat (Field)
- visited_lng (Field3)
Badge (뱃지)
- Badge_id (Key) — Primary key — NOT NULL
- badge_name (Field)
- description (Field2)
Coupon (쿠폰)
- Coupon_id (Key) — Primary key — NOT NULL
- store_id (Key2) — Foreign key → Store.store_id — NOT NULL
- qr_img_url (Field)
Crew (크루)
- Crew_id (Key) — Primary key — NOT NULL
- Member_id (Key2) — Foreign key → Member.Member_id — NOT NULL
- crewname (Field)
- invite_code (Field2)
- type (Field3)
- logo (Field4)
- image (Field5)
- member_count (Field6)
CrewMember (크루+멤버)
- CrewMember_id (Key3) — Primary key — NOT NULL
- Crew_id (Key) — Foreign key → Crew.Crew_id — NOT NULL
- Member_id (Key2) — Foreign key → Member.Member_id — NOT NULL
- Flag_id (Key4) — Foreign key → Flag.Flag_id — NOT NULL
CrewNotice (공지)
- CrewNotice_id (Key) — Primary key — NOT NULL
- Crew_id (Key2) — Foreign key → Crew.Crew_id — NOT NULL
- title (Field2)
- content (Field)
- created_at (Field3)
CrewNoticeReaction (크루가 공지에 좋아요/싫어요)
- CrewNotice_id (Key) — Foreign key → CrewNotice.CrewNotice_id — NOT NULL
- CrewMember_id (Key3) — Foreign key → CrewMember.CrewMember_id — NOT NULL
- Flag_id (Key4) — Foreign key → CrewMember.Flag_id — NOT NULL
- reaction (Field)
Flag (Untitled)
- Flag_id (Key) — Primary key — NOT NULL
- Member_id (Key2) — Foreign key → Member.Member_id — NOT NULL
- activity_type (Field)
- date (Field2)
- distance_km (Field3)
- time_record (Field4)
- group_photo (Field5)
- description (Field6)
GroupCertificationMember (인증요청한 회원 정보)
- id (Key2) — Primary key — NOT NULL
- Member_id (Key) — Foreign key → Member.Member_id — NOT NULL
- store_id (Key3) — Foreign key → Store.store_id — NOT NULL
- certification_lat (Field)
- certification_lng (Field2)
- status (Field3)
Location (장소)
- id (Key) — Primary key — NOT NULL
- Flag_id (Key2) — Foreign key → Flag.Flag_id — NOT NULL
- Member_id (Key22) — Foreign key → Flag.Member_id — NOT NULL
- name (Field)
- location_distance (Field2)
Member (회원)
- Member_id (Key) — Primary key — NOT NULL
- email (Field) — email
- password (Field2)
- nickname (Field3)
- password_check (Field4)
- profile_image (Field5)
- flag_count (Field6)
- total_distance (Field7)
- discounts_count (Field8)
- activites_count (Field9)
RouteRecommendation (경로 추천)
- Route_id (Key) — Primary key — NOT NULL
- CrewMember_id (Key3) — Foreign key → CrewMember.CrewMember_id — NOT NULL
- Flag_id (Key4) — Foreign key → CrewMember.Flag_id — NOT NULL
- Badge_id (Key222) — Foreign key — NOT NULL
- Member_id (Key2222) — Foreign key — NOT NULL
- Badge_id (Key22222) — Foreign key — NOT NULL
- start_location (Field)
- target_distance (Field2)
- route_path (Field3)
Store (제휴맺은가게들)
- store_id (Key) — Primary key — NOT NULL
- lat (Field)
- lng (Field2)
- required_count (Field3)
UserBadge (Untitled2)
- Member_id (Key) — Foreign key → Member.Member_id — NOT NULL
- Badge_id (Key2) — Foreign key → Badge.Badge_id — NOT NULL