54

Tables (5)

Pictures (Untitled2)

  • Name (Key) — varchar(100) — Primary key — NOT NULL
  • Picturelink (Field) — varchar(500)

Review (Untitled3)

  • review_id (PK) — int — Primary key — NOT NULL
  • Idnum (FK2) — int — Foreign key → Tour.Idnum — NOT NULL
  • user_id (FK) — varchar(30) — Foreign key → Userinfo.user_id — NOT NULL
  • rate (Field2) — int
  • review (Field3) — varchar(300)

Tour (Untitled)

  • Idnum (PK) — int — Primary key — NOT NULL
  • Name (Key) — varchar(100) — Foreign key → Pictures.Name — NOT NULL
  • Tel (Field2) — varchar(25)
  • Big_col (Field3) — varchar(40)
  • Mid_col (Field4) — varchar(15)
  • Small_col (Field5) — varchar(25)
  • City (Field6) — varchar(10)
  • County (Field7) — varchar(30)
  • Incity (Field8) — varchar(50)
  • Address (Field9) — varchar(100)
  • Tourinfo (Field10) — varchar(500)

Userinfo (Untitled4)

  • user_id (Key) — varchar(30) — Primary key — NOT NULL
  • email (Field) — varchar(45)
  • password (Field2) — varchar(45)
  • auth (Field3) — varchar(45)

description (Untitled5)

  • description (Field) — varchar(200) — Primary key
  • Name (Key) — varchar(1000) — NOT NULL