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