togethertrip
Tables (5)
Account (Untitled)
- id (Key) — int primary_key — Primary key — NOT NULL
- account_id (Field) — varchar(45)
- account_pw (Field2) — varchar(45)
Board (Untitled5)
- id (Key2) — int, pk, auto_increment — Primary key — NOT NULL
- user_id (Key) — int, primary_key, auto_increment — Foreign key → UserProfile.id — NOT NULL
- title (Field) — varchar(50)
- url (Field2) — varchar(200)
UserProfile (Untitled2)
- id (Key) — int, primary_key, auto_increment — Primary key — NOT NULL
- account_id (Key2) — int primary_key — Foreign key → Account.id — NOT NULL
- username (Field) — varchar(45)
- age (Field2) — int
- gender (Field3) — int
- location (Field4) — int
- image (Field5) — varchar(500)
- introduce (Field6) — varchar(400)
plan (Untitled3)
- id (Key) — int primary_key auto_increment — Primary key — NOT NULL
- user_id (Key2) — int, primary_key, auto_increment — Foreign key → UserProfile.id — NOT NULL
- wish (Field) — varchar(500)
- start_date (Field2) — date
- end_date (Field3) — date
- places (Field4) — varchar(500)
planBasedOnPlace (Untitled4)
- id (Key) — int primary_key auto_increment — Primary key — NOT NULL
- plan_id (Key2) — int primary_key auto_increment — Foreign key → plan.id — NOT NULL
- place_title (Field) — varchar(50)
- latitude (Field2) — decimal(20, 17)
- longitude (Field3) — decimal(20, 17)
- image (Field4) — varchar(200)
- accept_user (Field5) — varchar(200)
- waiting_user (Field6) — varchar(200)