Tripmall
Tables (14)
Cart (CopyOfCopyOfCopyOfCopyOfUntitled2)
- Key (cid) — int — Primary key — NOT NULL
- Field1 (userid) — Int
- Field4 (content_type_id) — Int
- Field5 (content_id) — Int
- Field6 (latitude) — real
- Field7 (longitude) — real
- Field (areacode) — int
- Field (title) — String
Overview (CopyOfCopyOfUntitled)
- Key (oid) — int — Primary key — NOT NULL
- Field1 (content_id) — Int
- Field (content_type_id) — Int
- Field (overview) — text
- Field (homepage)
Recommend (CopyOfCopyOfCopyOfUntitled2)
- Key (rid) — int — Primary key — NOT NULL
- Field1 (contentid) — Int
- Field2 (contenttypeid) — Int
- Field3 (subcontentid) — Int
- Field4 (subdetailalt) — String
- Field5 (subdetailimg) — String
- Field6 (subdetailoverview) — String
- Field7 (subname) — String
- Field8 (subnum) — Int
Route (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- Key (route_id) — int — Primary key — NOT NULL
- Field1 (userid) — Int
- Field2 (areacode) — Int
- Field3 (title) — String
- Field4 (thumbnail) — String
- Field5 (readcount) — Int
- Field6 (latitude) — real
- Field7 (longitude) — real
TourAndDining (CopyOfUntitled)
- Key (content_id) — Int — Primary key — NOT NULL
- Field1 (addr1) — String
- Field2 (addr2) — String
- Field3 (areacode) — String
- Field4 (cat1) — String
- Field5 (cat2) — String
- Field6 (cat3) — String
- Field8 (content_type_id) — Int
- Field9 (first_image) — String
- Field10 (first_image2) — String
- Field11 (mapx) — real
- Field12 (mapy) — real
- Field13 (sigungucode) — Int
- Field14 (tel) — String
- Field15 (title) — String
- Field16 (readcount) — Int
- Field17 (creation_date) — Date
- Field18 (modified_date) — Date
- Field19 (score) — double
User (Untitled)
- Key (id) — int — Primary key — NOT NULL
- Field0 (email) — String
- Field1 (nickname) — String
- Field2 (profile_image) — String
- Field3 (gender) — String
- Field4 (age_range) — String
courseinfo (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3)
- Field1 (content_id) — int — Primary key
- Field (distance) — String
- Field (info_center) — String
- Field (schedule) — String
- Field (spend_time) — String
- Field (theme) — String
cultureinfo (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3)
- Key (content_id) — int — Primary key — NOT NULL
- Field1 (capacity) — text
- Field (baby_carriage) — String
- Field (credit_card) — String
- Field (pet) — String
- Field (discount_info) — text
- Field (info_center) — text
- Field (parking) — String
- Field (rest_date) — String
- Field (parking_fee) — text
- Field (use_time) — text
- Field (use_fee) — text
- Field (scale) — text
- Field (spend_time) — String
festivalinfo (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3)
- Field1 (content_id) — int — Primary key
- Field (playtime) — text
- Field (program) — text
- Field (sponsor1tel) — String
- Field (sponsor2tel) — text
- Field (age_limit) — text
- Field (reservation_place) — text
- Field (start_date) — Date
- Field (end_date) — Date
- Field (place) — text
- Field (festival_grade) — text
- Field (place_guide) — text
- Field (spend_time) — String
- Field (organizer) — String
- Field (host) — String
- Field (sub_event) — text
- Field (use_fee) — text
foodinfo (CopyOfCopyOfCopyOfCopyOfUntitled3)
- Key (fid) — int — Primary key — NOT NULL
- Field1 (content_id) — Int
- Field (discountinfofood) — String
- Field (lcnsno) — int
- Field (credit_card) — String
- Field (discount_info) — String
- Field (rep_menu) — String
- Field (info_center) — String
- Field (kids_facility) — int
- Field (open_date) — String
- Field (open_time) — text
- Field (packing) — String
- Field (parking) — String
- Field (reservation_info) — text
- Field (rest_date) — String
- Field (scale) — String
- Field (seat) — String
- Field (smoking) — String
- Field (treat_menus) — text
leisureinfo (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled32)
- Key (content_id) — int — Primary key — NOT NULL
- Field1 (capacity) — text
- Field (baby_carriage) — String
- Field (credit_card) — String
- Field (pet) — String
- Field (age_range) — String
- Field (info_center) — text
- Field (parking) — String
- Field (rest_date) — String
- Field (parking_fee) — text
- Field (reservation_info) — text
- Field (use_fee) — text
- Field (scale) — text
- Field (use_time) — text
review (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- Key (rid) — int — Primary key — NOT NULL
- Field1 (uid) — Int
- Field5 (content_id) — Int
- Field6 (score) — int
- Field7 (comment) — String
- Field (write_time) — Date
routedetail (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- Key (rdid) — int — Primary key — NOT NULL
- Field1 (routeid) — Int
- Field2 (subnum) — Int
- Field3 (subtitle) — String
- Field4 (subimg) — String
- Field5 (suboverview) — text
- Field6 (subcontentid) — int
- Field7 (subcontenttypeid) — int
- Field (latitude) — real
- Field (longitude) — real
- Field (areacode) — int
tourinfo (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled3)
- Key (content_id) — int — Primary key — NOT NULL
- Field1 (capacity) — text
- Field (baby_carriage) — String
- Field (credit_card) — String
- Field (pet) — String
- Field (age_range) — text
- Field (info_center) — String
- Field (guide) — text
- Field (open_date) — String
- Field (parking) — String
- Field (rest_date) — String
- Field (season) — String
- Field (use_time) — text
- Field (cultural_heritage) — boolean
- Field (natural_heritage) — boolean
- Field (archival_heritage) — boolean