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