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)