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