triPlan

Tables (10)

Attraction (관광지)

  • no (Key) — Long — Primary key — NOT NULL
  • sido_id (Key2) — Long — Foreign key → Sido.sido_id — NOT NULL
  • name (Field) — String
  • latitude (Field2) — Double
  • longitude (Field3) — Double
  • addr1 (Field4) — String
  • addr2 (Field5) — String
  • img (Field6) — String
  • homepage (Field7) — String
  • title (Field8) — String
  • overview (Field10) — String

AttractionDate (Untitled)

  • attraction_date_id (Key) — Long — Primary key — NOT NULL
  • attraction_id (Key2) — Long — Foreign key → Attraction.no — NOT NULL
  • date_id (Key3) — Long — Foreign key → Day.data_id — NOT NULL

AttractionLike (Untitled3)

  • Key — Primary key — NOT NULL
  • member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
  • attraction_id (Key3) — Long — Foreign key → Attraction.no — NOT NULL

Day (Untitled5)

  • data_id (Key) — Long — Primary key — NOT NULL
  • share_plan_id (Key2) — Long — Foreign key → Plan.share_plan_id — NOT NULL
  • day (Field) — Integer

Member (사용자)

  • member_id (Key) — Long — Primary key — NOT NULL
  • password (Field1) — String
  • name (Field2) — String
  • email (Field3) — String
  • phone (Field4) — String
  • regDate (Field5) — DATE
  • nickName (Field6) — String
  • birthday (Field7) — String

MemberPlan (Untitled2)

  • member_plan_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
  • plan_id (Key3) — Long — Foreign key → Plan.share_plan_id — NOT NULL
  • member_id (Key22) — Long — Foreign key → Plan.member_id — NOT NULL

Plan (계획)

  • share_plan_id (Key) — Long — Primary key — NOT NULL
  • member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
  • regDate (Field2)
  • star (Field4)

PlanLike (Untitled4)

  • Key — Primary key — NOT NULL
  • plan_id (Key2) — Long — Foreign key → Plan.share_plan_id — NOT NULL
  • member_id (Key3) — Long — Foreign key → Member.member_id — NOT NULL

PlanSido (Untitled7)

  • Key — Primary key — NOT NULL
  • sido_id (Key2) — Long — Foreign key → Sido.sido_id — NOT NULL
  • share_plan_id (Key3) — Long — Foreign key → Plan.share_plan_id — NOT NULL

Sido (Untitled6)

  • sido_id (Key) — Long — Primary key — NOT NULL
  • sido_code (Field) — Int
  • sido_name (Field2) — String