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