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