complete_travel_web

Tables (14)

Board (Untitled)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • id (Key2) — INT(10) — Foreign key → User.id — NOT NULL
  • id (Key3) — INT(10) — Foreign key → Country.id — NOT NULL
  • id (Key22) — INT(10) — Foreign key → Country.id — NOT NULL
  • city (Field) — CHAR(20)
  • title (Field2) — CHAR(50)
  • star (Field3) — INT(5)
  • content (Field4) — HTMLField
  • creat_dt (Field5) — DATETIME
  • modify_dt (Field6) — DATETIME
  • tags (Field7) — TaggleManager
  • Field8

Board_attachfile (Untitled2)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • id (Key2) — INT(10) — Foreign key → Board.id — NOT NULL
  • id (Key22) — INT(10) — Foreign key → Board.id — NOT NULL
  • id (Key3) — INT(10) — Foreign key → Board.id — NOT NULL
  • id (Key222) — INT(10) — Foreign key → Board.id — NOT NULL
  • upload_file (Field) — FILE
  • filename (Field2) — CHAR(20)
  • content_tyle (Field3) — CHAR(20)
  • size (Field4) — INT(100)

City (Untitled5)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • id (Key2) — INT(10) — Foreign key → User.id — NOT NULL
  • id (Key3) — INT(10) — Foreign key → Country.id — NOT NULL
  • id (Key22) — INT(10) — Foreign key → Country.id — NOT NULL
  • id (Key4) — INT(10) — Foreign key → Detail_city.id — NOT NULL
  • slug (Field) — SLIG
  • card_content (Field2) — HTML
  • main_comtent (Field3) — HTML
  • creat_dt (Field4) — DATETIME
  • modify_dt (Field5) — DATETIME
  • tags (Field6) — TAGGLE

City_attachfile (CopyOfUntitled2)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • id (Key2) — INT(10) — Foreign key → City.id — NOT NULL
  • id (Key22) — INT(10) — Foreign key → City.id — NOT NULL
  • id (Key3) — INT(10) — Foreign key → City.id — NOT NULL
  • id (Key222) — INT(10) — Foreign key → City.id — NOT NULL
  • id (Key4) — INT(10) — Foreign key → City.id — NOT NULL
  • upload_file (Field) — FILE
  • filename (Field2) — CHAR(20)
  • content_tyle (Field3) — CHAR(20)
  • size (Field4) — INT(100)

Comment (Untitled3)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • id (Key2) — INT(10) — Foreign key → User.id — NOT NULL
  • id (Key3) — INT(10) — Foreign key → Board.id — NOT NULL
  • id (Key22) — INT(10) — Foreign key → Board.id — NOT NULL
  • id (Key32) — INT(10) — Foreign key → Board.id — NOT NULL
  • id (Key222) — INT(10) — Foreign key → Board.id — NOT NULL
  • text (Field) — TEXTFIELD
  • create_dt (Field2) — DATETIME

Country (CopyOfUntitled5)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • id (Key2) — INT(10) — Foreign key → User.id — NOT NULL
  • slug (Field) — SLIG
  • card_content (Field2) — HTML
  • main_comtent (Field3) — HTML
  • creat_dt (Field4) — DATETIME
  • modify_dt (Field5) — DATETIME
  • tags (Field6) — TAGGLE

Country_attachfile (CopyOfCopyOfUntitled2)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • id (Key2) — INT(10) — Foreign key → Country.id — NOT NULL
  • id (Key22) — INT(10) — Foreign key → Country.id — NOT NULL
  • upload_file (Field) — FILE
  • filename (Field2) — CHAR(20)
  • content_tyle (Field3) — CHAR(20)
  • size (Field4) — INT(100)

Detail_city (CopyOfUntitled52)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • slug (Field) — SLIG
  • card_content (Field2) — HTML
  • main_comtent (Field3) — HTML
  • creat_dt (Field4) — DATETIME
  • modify_dt (Field5) — DATETIME
  • tags (Field6) — TAGGLE
  • latitude (Field7) — FLOAT(120)
  • longitude (Field8) — FLOAT(120)

Detail_city_attachfile (CopyOfCopyOfUntitled22)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • id (Key2) — INT(10) — Foreign key → Detail_city.id — NOT NULL
  • upload_file (Field) — FILE
  • filename (Field2) — CHAR(20)
  • content_tyle (Field3) — CHAR(20)
  • size (Field4) — INT(100)

Festival (CopyOfCopyOfUntitled52)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • id (Key2) — INT(10) — Foreign key → City.id — NOT NULL
  • id (Key22) — INT(10) — Foreign key → City.id — NOT NULL
  • id (Key3) — INT(10) — Foreign key → City.id — NOT NULL
  • id (Key222) — INT(10) — Foreign key → City.id — NOT NULL
  • id (Key4) — INT(10) — Foreign key → City.id — NOT NULL
  • slug (Field) — SLIG
  • card_content (Field2) — HTML
  • main_comtent (Field3) — HTML
  • creat_dt (Field4) — DATETIME
  • modify_dt (Field5) — DATETIME
  • tags (Field6) — TAGGLE

Festival_attachfile (CopyOfCopyOfCopyOfUntitled22)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • id (Key2) — INT(10) — Foreign key → Festival.id — NOT NULL
  • id (Key22) — INT(10) — Foreign key → Festival.id — NOT NULL
  • id (Key222) — INT(10) — Foreign key → Festival.id — NOT NULL
  • id (Key3) — INT(10) — Foreign key → Festival.id — NOT NULL
  • id (Key2222) — INT(10) — Foreign key → Festival.id — NOT NULL
  • id (Key4) — INT(10) — Foreign key → Festival.id — NOT NULL
  • upload_file (Field) — FILE
  • filename (Field2) — CHAR(20)
  • content_tyle (Field3) — CHAR(20)
  • size (Field4) — INT(100)

Food (CopyOfCopyOfUntitled522)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • id (Key2) — INT(10) — Foreign key → Country.id — NOT NULL
  • id (Key22) — INT(10) — Foreign key → Country.id — NOT NULL
  • slug (Field) — SLIG
  • card_content (Field2) — HTML
  • main_comtent (Field3) — HTML
  • creat_dt (Field4) — DATETIME
  • modify_dt (Field5) — DATETIME
  • tags (Field6) — TAGGLE

Food_attachfile (CopyOfCopyOfCopyOfUntitled222)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • id (Key2) — INT(10) — Foreign key → Food.id — NOT NULL
  • id (Key22) — INT(10) — Foreign key → Food.id — NOT NULL
  • id (Key222) — INT(10) — Foreign key → Food.id — NOT NULL
  • upload_file (Field) — FILE
  • filename (Field2) — CHAR(20)
  • content_tyle (Field3) — CHAR(20)
  • size (Field4) — INT(100)

User (Untitled4)

  • id (Key) — INT(10) — Primary key — NOT NULL
  • password (Field) — CHAR(128)
  • last_login (Field2) — DATETIME
  • is_superuser (Field3) — BIT(1)
  • username (Field4) — CHAR(150)
  • nick_name (Field5) — CHAR(150)
  • emai (Field6) — CHAR(254)