Web_project
Tables (10)
city (Untitled4)
- City_index (Key) — INT(11) — Primary key — NOT NULL
- Country_index (Key2) — INT(11) — Foreign key → country.Country_index — NOT NULL
- Continent_index (Key22) — INT(11) — Foreign key → country.Continent_index — NOT NULL
- city_name (Field) — VARCHAR(20)
- city_map (Field6) — MAP_DATA
- city_map_info (Field7) — TEXT
city_festival (CopyOfCopyOfUntitled6)
- Festival_index (Key) — INT(11) — Primary key — NOT NULL
- City_index (Key2) — INT(11) — Foreign key → city.City_index — NOT NULL
- Country_index (Key22) — INT(11) — Foreign key → city.Country_index — NOT NULL
- Continent_index (Key222) — INT(11) — Foreign key → city.Continent_index — NOT NULL
- picture_name (Field2) — IMAGE
- picture_info (Field) — TEXT
city_food (CopyOfUntitled7)
- Food_index (Key) — INT(11) — Primary key — NOT NULL
- City_index (Key2) — INT(11) — Foreign key → city.City_index — NOT NULL
- Country_index (Key22) — INT(11) — Foreign key → city.Country_index — NOT NULL
- Continent_index (Key222) — INT(11) — Foreign key → city.Continent_index — NOT NULL
- food_name (Field) — IMAGE
- food_info (Field2) — TEXT
city_picture (CopyOfUntitled6)
- Picture_index (Key) — INT(11) — Primary key — NOT NULL
- City_index (Key2) — INT(11) — Foreign key → city.City_index — NOT NULL
- Country_index (Key22) — INT(11) — Foreign key → city.Country_index — NOT NULL
- Continent_index (Key222) — INT(11) — Foreign key → city.Continent_index — NOT NULL
- picture_name (Field2) — IMAGE
- picture_info (Field) — TEXT
continent (Untitled2)
- Continent_index (Key) — INT(11) — Primary key — NOT NULL
- continent_name (Field) — VARCHAR(10)
country (Untitled3)
- Country_index (Key) — INT(11) — Primary key — NOT NULL
- Continent_index (Key2) — INT(11) — Foreign key → continent.Continent_index — NOT NULL
- country_name (Field) — VARCHAR(20)
country_food (Untitled7)
- Food_index (Key) — INT(11) — Primary key — NOT NULL
- Country_index (Key2) — INT(11) — Foreign key → country.Country_index — NOT NULL
- Continent_index (Key22) — INT(11) — Foreign key → country.Continent_index — NOT NULL
- food_name (Field) — IMAGE
- food_info (Field2) — TEXT
country_picture (Untitled6)
- Picture_index (Key) — INT(11) — Primary key — NOT NULL
- Country_index (Key2) — INT(11) — Foreign key → country.Country_index — NOT NULL
- Continent_index (Key22) — INT(11) — Foreign key → country.Continent_index — NOT NULL
- picture_name (Field2) — IMAGE
- picture_info (Field) — TEXT
id (Untitled)
- ID (Key) — VARCHAR(20) — Primary key — NOT NULL
- password (Field2) — VARCHAR(20)
- e-mail (Field3) — VARCHAR(20)
- usperuser (Field) — BIT(1)
- is_active (Field4) — BIT(1)
review (Untitled5)
- Review_index (Key) — INT(11) — Primary key — NOT NULL
- ID (Key2) — VARCHAR(20) — Foreign key → id.ID — NOT NULL
- Country_index (Key3) — INT(11) — Foreign key → country.Country_index — NOT NULL
- Continent_index (Key22) — INT(11) — Foreign key → country.Continent_index — NOT NULL
- title (Field) — VARCHAR(20)
- date (Field2) — DATE
- modify_date (Field3) — DATE
- read_cnt (Field4) — INT(11)
- review_score (Field5) — INT(3)
- contents (Field6) — TEXT