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)