mapo
Tables (20)
banner
- seq — int — Primary key — NOT NULL
- bannerKey — varchar(50)
- bannerName — varchar(50) — NOT NULL
- bannerLink — varchar(50) — NOT NULL
- bannerImg — varchar(50) — NOT NULL
- bannerActive — int — NOT NULL
- bannerOrder — int
category
- seq — int — Primary key — NOT NULL
- categoryClassification — int — NOT NULL
- categoryName — varchar(50) — NOT NULL
- categoryOrder — int
commentator
- seq — int — Primary key — NOT NULL
- commentatorKey — varchar(50) — NOT NULL
- commentatorName — varchar(50)
- commentatorPhone — varchar(50)
- commentatorEmail — varchar(50)
- commentatorDescription — varchar(1000)
company
- seq — int — Primary key — NOT NULL
- companyKey — varchar(50)
- companyName — varchar(50) — NOT NULL
- companyLink — varchar(50) — NOT NULL
- companyImg — varchar(50) — NOT NULL
- companyActive — int — NOT NULL
- companyOrder — int
connectplace
- ownerKey — varchar(50) — NOT NULL
- placeKey — varchar(50) — Foreign key → place.placeKey — NOT NULL
- connectplaceOrder — int — NOT NULL
extradata
- ownerKey — varchar(50) — NOT NULL
- extraKey — varchar(50) — Foreign key → extrafield.extraKey — NOT NULL
- extraData — varchar(200) — NOT NULL
extrafield
- extraKey — varchar(50) — Primary key — NOT NULL
- seq — int — NOT NULL
- ownerClassification — int — NOT NULL
- extraTitle — varchar(50) — NOT NULL
- extraActive — int — NOT NULL
faq
- seq — int — Primary key — NOT NULL
- categorySeq — int — Foreign key → category.seq
- faqSubject — varchar(100) — NOT NULL
- faqWriter — varchar(100) — NOT NULL
- faqContents — varchar(1000) — NOT NULL
- faqRegDate — datetime — NOT NULL
- faqHits — int — NOT NULL
images
- seq — int — Primary key — NOT NULL
- ownerKey — varchar(50) — NOT NULL
- imagesFile — varchar(50) — NOT NULL
- imagesTitle — varchar(50) — NOT NULL
- imagesActive — int — NOT NULL
- imagesOrder — int — NOT NULL
- seq — int — Primary key — NOT NULL
- mailSenderName — varchar(50) — NOT NULL
- mailSenderEmail — varchar(50) — NOT NULL
- mailTitle — varchar(50) — NOT NULL
- mailContents — varchar(50) — NOT NULL
- mailFile — varchar(50) — NOT NULL
member
- memberKey — varchar(50) — Primary key — NOT NULL
- memberId — varchar(100) — NOT NULL
- memberPwd — varchar(100) — NOT NULL
- memberName — varchar(100) — NOT NULL
- memberPhone — varchar(100)
- memberEmail — varchar(100)
- memberAuth — int — NOT NULL
- memberRegDate — datetime — NOT NULL
- memberRecentLogin — datetime
- ENABLED — tinyint — NOT NULL
notice
- seq — int — Primary key — NOT NULL
- noticeTopFix — int — NOT NULL
- categorySeq — int — Foreign key → category.seq
- noticeSubject — varchar(200) — NOT NULL
- noticeWriter — varchar(200) — NOT NULL
- noticeFileFirst — varchar(200)
- noticeFileSecond — varchar(200)
- noticeContents — mediumtext — NOT NULL
- noticeContentImgs — varchar(200) — NOT NULL
- noticeRegDate — datetime — NOT NULL
- noticeHits — int — NOT NULL
place
- placeKey — varchar(50) — Primary key — NOT NULL
- seq — int — NOT NULL
- categorySeq — int — Foreign key → category.seq
- placeName — varchar(200) — NOT NULL
- placeLat — double — NOT NULL
- placeLng — double — NOT NULL
- placeAddress — varchar(200) — NOT NULL
- placeThumbnail — varchar(200) — NOT NULL
- placeInfo — varchar(5000) — NOT NULL
- placeOperatingTime — varchar(200) — NOT NULL
- placeTel — varchar(200) — NOT NULL
- placeHomepage — varchar(200) — NOT NULL
- placeSNS — varchar(200) — NOT NULL
- placeAdminMemo — varchar(5000) — NOT NULL
- placeActive — int — NOT NULL
productlist
- productKey — varchar(50) — Primary key — NOT NULL
- ownerKey — varchar(50) — NOT NULL
- productDate — date
- productCost — int — NOT NULL
- productMin — int — NOT NULL
- productMax — int — NOT NULL
- commentatorKey — varchar(50) — Foreign key → commentator.commentatorKey
productoption
- productKey — varchar(50) — Foreign key → productlist.productKey — NOT NULL
- optionName — varchar(50)
- optionData — varchar(50)
program
- programKey — varchar(50) — Primary key — NOT NULL
- seq — int — NOT NULL
- categorySeq — int — Foreign key → category.seq
- programName — varchar(200) — NOT NULL
- programDescription — varchar(5000) — NOT NULL
- programPlace — varchar(200) — NOT NULL
- programTime — varchar(200) — NOT NULL
- programCost — varchar(200) — NOT NULL
- programQuestion — varchar(200) — NOT NULL
- programHomepage — varchar(200) — NOT NULL
- programSNS — varchar(200) — NOT NULL
- programLink — varchar(200) — NOT NULL
- programThumbnail — varchar(200) — NOT NULL
- programMainImg — varchar(200)
- programTopImg — varchar(200)
- programTop — int — NOT NULL
- programActive — int — NOT NULL
- programAdminMemo — varchar(5000) — NOT NULL
- programOrder — int
taglist
- ownerKey — varchar(50) — NOT NULL
- tagName — varchar(50) — NOT NULL
- tagOrder — int — NOT NULL
travel
- travelKey — varchar(50) — Primary key — NOT NULL
- seq — int — NOT NULL
- categorySeq — int — Foreign key → category.seq
- travelName — varchar(200)
- travelDescription — varchar(5000)
- travelHost — varchar(200)
- travelUser — varchar(200)
- travelSchedule — varchar(200)
- travelCost — varchar(200)
- travelLink — varchar(200)
- travelThumbnail — varchar(200)
- travelMainImg — varchar(200)
- travelProgress — int
- travelActive — int
- travelAdminMemo — varchar(5000)
- travelHits — int
- travelOrder — int
travellike
- travelKey — varchar(50) — Foreign key → travel.travelKey — NOT NULL
- memberKey — varchar(50) — Foreign key → member.memberKey — NOT NULL
travelroute
- travelKey — varchar(50) — Foreign key → travel.travelKey — NOT NULL
- beforeLat — double — NOT NULL
- beforeLng — double — NOT NULL
- nowLat — double — NOT NULL
- nowLng — double — NOT NULL
- routeOrder — int — NOT NULL