Table Definition

totalRelationSvg TOUR_PLAN TOUR_PLAN user user TOUR_PLAN->user LOCATION_COUNTRY LOCATION_COUNTRY user->LOCATION_COUNTRY PUBLIC_FILE PUBLIC_FILE user->PUBLIC_FILE PRODUCT_IMPOSSIBLE_DATE PRODUCT_IMPOSSIBLE_DATE PRODUCT PRODUCT PRODUCT_IMPOSSIBLE_DATE->PRODUCT PRODUCT->user PRODUCT_EVENT_TYPE PRODUCT_EVENT_TYPE PRODUCT->PRODUCT_EVENT_TYPE CURRENCY CURRENCY PRODUCT->CURRENCY UNIT_TOUR UNIT_TOUR TOUR TOUR UNIT_TOUR->TOUR TOUR->PRODUCT CONFIRMATION CONFIRMATION PRODUCT_RESERVATION PRODUCT_RESERVATION CONFIRMATION->PRODUCT_RESERVATION PRODUCT_RESERVATION->user PRODUCT_RESERVATION->PRODUCT PRODUCT_RESERVATION->CURRENCY PRODUCT_RESERVATION->LOCATION_COUNTRY THEME THEME PRODUCT_RESERVATION->THEME KEYWORD KEYWORD LOCATION_STATE LOCATION_STATE LOCATION_STATE->LOCATION_COUNTRY USER_X_INTEREST_GUIDE USER_X_INTEREST_GUIDE USER_X_INTEREST_GUIDE->user GUIDE GUIDE USER_X_INTEREST_GUIDE->GUIDE GUIDE->user GUIDE_EVENT_TYPE GUIDE_EVENT_TYPE GUIDE->GUIDE_EVENT_TYPE LOCATION_CITY LOCATION_CITY GUIDE->LOCATION_CITY LOCATION_CITY->LOCATION_STATE TOURIST_FACEBOOK TOURIST_FACEBOOK TOURIST TOURIST TOURIST_FACEBOOK->TOURIST TOURIST->user TOUR_SKETCH TOUR_SKETCH TOUR_SKETCH->TOUR_PLAN GUIDE_X_LANGUAGE GUIDE_X_LANGUAGE GUIDE_X_LANGUAGE->GUIDE LANGUAGE LANGUAGE GUIDE_X_LANGUAGE->LANGUAGE COUNTRY_X_LANGUAGE COUNTRY_X_LANGUAGE COUNTRY_X_LANGUAGE->LOCATION_COUNTRY COUNTRY_X_LANGUAGE->LANGUAGE PRODUCT_X_CITY PRODUCT_X_CITY PRODUCT_X_CITY->PRODUCT PRODUCT_X_CITY->LOCATION_CITY SERVICE SERVICE SERVICE->PRODUCT SERVICE_TYPE SERVICE_TYPE SERVICE->SERVICE_TYPE ADMIN ADMIN ADMIN->user TOURIST_KAKAOTALK TOURIST_KAKAOTALK TOURIST_KAKAOTALK->TOURIST THEME->THEME THEME->PUBLIC_FILE TOUR_SCHEDULE TOUR_SCHEDULE TOUR_SCHEDULE->TOUR_PLAN TOUR_SCHEDULE_NODE_MEDIA_FILE TOUR_SCHEDULE_NODE_MEDIA_FILE TOUR_SCHEDULE_NODE TOUR_SCHEDULE_NODE TOUR_SCHEDULE_NODE_MEDIA_FILE->TOUR_SCHEDULE_NODE TOUR_SCHEDULE_NODE_MEDIA_FILE->PUBLIC_FILE TOUR_SCHEDULE_DAY TOUR_SCHEDULE_DAY TOUR_SCHEDULE_NODE->TOUR_SCHEDULE_DAY COURSE COURSE TOUR_SCHEDULE_NODE->COURSE TOUR_SCHEDULE_DAY->TOUR_SCHEDULE COURSE->UNIT_TOUR TOURIST_TWITTER TOURIST_TWITTER TOURIST_TWITTER->TOURIST USER_X_INTEREST_PRODUCT USER_X_INTEREST_PRODUCT USER_X_INTEREST_PRODUCT->user USER_X_INTEREST_PRODUCT->PRODUCT NOTICE NOTICE NOTICE->user CUSTOM_TOUR CUSTOM_TOUR CUSTOM_TOUR->TOUR_PLAN CUSTOM_TOUR->TOUR FAQ_CATEGORY FAQ_CATEGORY FAQ_CATEGORY->FAQ_CATEGORY TOUR_PLAN_X_THEME TOUR_PLAN_X_THEME TOUR_PLAN_X_THEME->TOUR_PLAN TOUR_PLAN_X_THEME->THEME SELLER_IMPOSSIBLE_DATE SELLER_IMPOSSIBLE_DATE SELLER_IMPOSSIBLE_DATE->GUIDE MESSAGE MESSAGE MESSAGE->TOUR_PLAN MESSAGE->user MESSAGE->MESSAGE GUIDE_X_LICENSE GUIDE_X_LICENSE GUIDE_X_LICENSE->GUIDE GUIDE_X_LICENSE->PUBLIC_FILE TOUR_SKETCH_NODE TOUR_SKETCH_NODE TOUR_SKETCH_NODE->UNIT_TOUR TOUR_SKETCH_NODE->TOUR_SKETCH TOUR_SKETCH_NODE->TOUR_SKETCH TOUR_SKETCH_NODE->TOUR_SKETCH_NODE TOURIST_EMAIL TOURIST_EMAIL TOURIST_EMAIL->TOURIST PRODUCT_PRICE PRODUCT_PRICE PRODUCT_PRICE->PRODUCT FAQ FAQ FAQ->user FAQ->FAQ_CATEGORY TOURIST_GOOGLEPLUS TOURIST_GOOGLEPLUS TOURIST_GOOGLEPLUS->TOURIST COURSE_X_MEDIA_FILE COURSE_X_MEDIA_FILE COURSE_X_MEDIA_FILE->COURSE COURSE_X_MEDIA_FILE->PUBLIC_FILE PRODUCT_X_THEME PRODUCT_X_THEME PRODUCT_X_THEME->PRODUCT PRODUCT_X_THEME->THEME PRODUCT_X_KEYWORD PRODUCT_X_KEYWORD PRODUCT_X_KEYWORD->PRODUCT PRODUCT_X_KEYWORD->KEYWORD

ADMINuser of admin type

ADMIN ADMIN ADMIN user user ADMIN->user
column type nullable pkey defaulted referred refer
ID BIGINT
LOGIN_ID VARCHAR (100)
LOGIN_PASSWORD VARCHAR (100)
unique key columns description
CONSTRAINT_3B ID
ADMIN_LOGIN_ID_KEY LOGIN_ID
column description
ID table identifier
LOGIN_ID login ID
LOGIN_PASSWORD login password

CONFIRMATIONserves as evidence of tour

CONFIRMATION CONFIRMATION CONFIRMATION PRODUCT_RESERVATION PRODUCT_RESERVATION CONFIRMATION->PRODUCT_RESERVATION
column type nullable pkey defaulted referred refer
ID BIGINT
NAME VARCHAR (100)
ENGLISH_NAME VARCHAR (100)
EMAIL VARCHAR (100)
PHONE VARCHAR (100)
TOUR_TITLE VARCHAR (100)
TOURIST_NUM VARCHAR (100)
TOUR_DATE VARCHAR (100)
COST VARCHAR (100)
PAID VARCHAR (100)
CONTACTABLE_TIME VARCHAR (100)
MEETING_PLACE VARCHAR (100)
GUIDE_PHONE VARCHAR (100)
GUIDE VARCHAR (100)
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_73 ID
column description
ID table identifier
NAME name of tourist
ENGLISH_NAME english name of tourist
EMAIL email of tourist
PHONE phone number of tourist
TOUR_TITLE tour title
TOURIST_NUM tourist number
TOUR_DATE day when tour start
COST total tour cost
PAID present payment
CONTACTABLE_TIME contactable time with guide
MEETING_PLACE place where meet with guide
GUIDE_PHONE phone number of guide
GUIDE name of guide
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

COUNTRY_X_LANGUAGErelationship of country with language. languages are used as representative country.

COUNTRY_X_LANGUAGE COUNTRY_X_LANGUAGE COUNTRY_X_LANGUAGE LANGUAGE LANGUAGE COUNTRY_X_LANGUAGE->LANGUAGE LOCATION_COUNTRY LOCATION_COUNTRY COUNTRY_X_LANGUAGE->LOCATION_COUNTRY
column type nullable pkey defaulted referred refer
ID BIGINT
COUNTRY_ID BIGINT
LANGUAGE_ID BIGINT
unique key columns description
CONSTRAINT_DA ID
column description
ID table identifier
COUNTRY_ID reference country
LANGUAGE_ID reference language

COURSEcomponent what constitutes product. they are sequential about time.

COURSE COURSE COURSE UNIT_TOUR UNIT_TOUR COURSE->UNIT_TOUR COURSE_X_MEDIA_FILE COURSE_X_MEDIA_FILE COURSE_X_MEDIA_FILE->COURSE TOUR_SCHEDULE_NODE TOUR_SCHEDULE_NODE TOUR_SCHEDULE_NODE->COURSE
column type nullable pkey defaulted referred refer
ID BIGINT
[COURSE_X_MEDIA_FILE] COURSE_ID
[TOUR_SCHEDULE_NODE] COURSE_ID
UNIT_TOUR_ID BIGINT
TITLE VARCHAR (100)
DESCRIPTION CLOB (2147483647)
SEQUENCE INTEGER
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_76 ID
column description
ID table identifier
UNIT_TOUR_ID reference product
TITLE title of course
DESCRIPTION description
SEQUENCE sequence number
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

COURSE_X_MEDIA_FILEimage file what is comprised in one course.

COURSE_X_MEDIA_FILE COURSE_X_MEDIA_FILE COURSE_X_MEDIA_FILE PUBLIC_FILE PUBLIC_FILE COURSE_X_MEDIA_FILE->PUBLIC_FILE COURSE COURSE COURSE_X_MEDIA_FILE->COURSE
column type nullable pkey defaulted referred refer
ID BIGINT
COURSE_ID BIGINT
PUBLIC_FILE_ID BIGINT
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_8 ID
column description
ID table identifier
COURSE_ID reference course
PUBLIC_FILE_ID reference image file
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

CURRENCYdefine currency

CURRENCY CURRENCY CURRENCY PRODUCT_RESERVATION PRODUCT_RESERVATION PRODUCT_RESERVATION->CURRENCY PRODUCT PRODUCT PRODUCT->CURRENCY
column type nullable pkey defaulted referred refer
ID BIGINT
[PRODUCT] CURRENCY_ID
[PRODUCT_RESERVATION] CURRENCY_ID
NAME VARCHAR (2048)
unique key columns description
CONSTRAINT_5 ID
CURRENCY_NAME_KEY NAME
column description
ID table identifier
NAME name of currency

CUSTOM_TOURselling tour-product by guide manager

CUSTOM_TOUR CUSTOM_TOUR CUSTOM_TOUR TOUR_PLAN TOUR_PLAN CUSTOM_TOUR->TOUR_PLAN TOUR TOUR CUSTOM_TOUR->TOUR
column type nullable pkey defaulted referred refer
ID BIGINT
TOUR_PLAN_ID BIGINT
unique key columns description
CONSTRAINT_182 ID
column description
ID table identifier
TOUR_PLAN_ID reference tour plan

FAQfrequently asked questions

FAQ FAQ FAQ FAQ_CATEGORY FAQ_CATEGORY FAQ->FAQ_CATEGORY user user FAQ->user
column type nullable pkey defaulted referred refer
ID BIGINT
USER_ID BIGINT
QUESTION CLOB (2147483647)
ANSWER CLOB (2147483647)
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
CATEGORY_ID BIGINT
unique key columns description
CONSTRAINT_10 ID
column description
ID table identifier
USER_ID reference writer
QUESTION question
ANSWER answer
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted
CATEGORY_ID reference category

FAQ_CATEGORYcategory of "faq"

FAQ_CATEGORY FAQ_CATEGORY FAQ_CATEGORY FAQ_CATEGORY->FAQ_CATEGORY FAQ FAQ FAQ->FAQ_CATEGORY
column type nullable pkey defaulted referred refer
ID BIGINT
[FAQ] CATEGORY_ID
[FAQ_CATEGORY] REF_ID
NAME VARCHAR (2048)
REF_ID BIGINT
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_6A ID
column description
ID table identifier
NAME name of category
REF_ID refer anyone of "faq_category"
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

GUIDEuser of guide/guide manager type

GUIDE GUIDE GUIDE GUIDE_EVENT_TYPE GUIDE_EVENT_TYPE GUIDE->GUIDE_EVENT_TYPE LOCATION_CITY LOCATION_CITY GUIDE->LOCATION_CITY user user GUIDE->user GUIDE_X_LANGUAGE GUIDE_X_LANGUAGE GUIDE_X_LANGUAGE->GUIDE GUIDE_X_LICENSE GUIDE_X_LICENSE GUIDE_X_LICENSE->GUIDE SELLER_IMPOSSIBLE_DATE SELLER_IMPOSSIBLE_DATE SELLER_IMPOSSIBLE_DATE->GUIDE USER_X_INTEREST_GUIDE USER_X_INTEREST_GUIDE USER_X_INTEREST_GUIDE->GUIDE
column type nullable pkey defaulted referred refer
ID BIGINT
[GUIDE_X_LANGUAGE] GUIDE_ID
[GUIDE_X_LICENSE] GUIDE_ID
[SELLER_IMPOSSIBLE_DATE] SELLER_ID
[USER_X_INTEREST_GUIDE] GUIDE_ID
STATUS ENUM
GUIDE_EVENT_TYPE_ID BIGINT
LOGIN_ID VARCHAR (100)
LOGIN_PASSWORD VARCHAR (100)
EMAIL_GENERATE_KEY VARCHAR (255)
EMAIL_CERTIFIED_AT TIMESTAMP
SKYPE_ID VARCHAR (40)
RESIDENTIAL_CITY_ID BIGINT
EXPERIENCE INTEGER
AGE INTEGER
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_41 ID
GUIDE_LOGIN_ID_KEY LOGIN_ID
column description
ID table identifier
STATUS approved by administrator
GUIDE_EVENT_TYPE_ID promotion about guide
LOGIN_ID login ID
LOGIN_PASSWORD login password
EMAIL_GENERATE_KEY generated key for certificating email
EMAIL_CERTIFIED_AT timestamp when email is certificated
SKYPE_ID skype ID
RESIDENTIAL_CITY_ID city of residence
EXPERIENCE n years experience about guiding
AGE age
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

GUIDE_EVENT_TYPEdefine promotion type about guide

GUIDE_EVENT_TYPE GUIDE_EVENT_TYPE GUIDE_EVENT_TYPE GUIDE GUIDE GUIDE->GUIDE_EVENT_TYPE
column type nullable pkey defaulted referred refer
ID BIGINT
[GUIDE] GUIDE_EVENT_TYPE_ID
NAME VARCHAR (255)
MARKER VARCHAR (2048)
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_D5 ID
GUIDE_EVENT_TYPE_NAME_KEY NAME
column description
ID table identifier
NAME name of promotion
MARKER mark as
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

GUIDE_X_LANGUAGErelationship of guide with language. One guide has 1 guiding-language or more.

GUIDE_X_LANGUAGE GUIDE_X_LANGUAGE GUIDE_X_LANGUAGE LANGUAGE LANGUAGE GUIDE_X_LANGUAGE->LANGUAGE GUIDE GUIDE GUIDE_X_LANGUAGE->GUIDE
column type nullable pkey defaulted referred refer
ID BIGINT
GUIDE_ID BIGINT
LANGUAGE_ID BIGINT
unique key columns description
CONSTRAINT_49 ID
GUIDE_X_LANGUAGE_GUIDE_ID_LANGUAGE_ID_KEY GUIDE_IDLANGUAGE_ID
column description
ID table identifier
GUIDE_ID reference guide
LANGUAGE_ID reference language

GUIDE_X_LICENSErelationship of guide with license.

GUIDE_X_LICENSE GUIDE_X_LICENSE GUIDE_X_LICENSE GUIDE GUIDE GUIDE_X_LICENSE->GUIDE PUBLIC_FILE PUBLIC_FILE GUIDE_X_LICENSE->PUBLIC_FILE
column type nullable pkey defaulted referred refer
ID BIGINT
GUIDE_ID BIGINT
LICENSE_PICTURE_FILE_ID BIGINT
LICENSE_NAME VARCHAR (255)
unique key columns description
CONSTRAINT_7 ID
column description
ID table identifier
GUIDE_ID reference guide
LICENSE_PICTURE_FILE_ID reference picture file about license
LICENSE_NAME name of license

KEYWORDdefine keyword for product classification

KEYWORD KEYWORD KEYWORD PRODUCT_X_KEYWORD PRODUCT_X_KEYWORD PRODUCT_X_KEYWORD->KEYWORD
column type nullable pkey defaulted referred refer
ID BIGINT
[PRODUCT_X_KEYWORD] KEYWORD_ID
NAME VARCHAR (2048)
unique key columns description
CONSTRAINT_F ID
KEYWORD_NAME_KEY NAME
column description
ID table identifier
NAME name of keyword

LANGUAGEdefine language for guiding

LANGUAGE LANGUAGE LANGUAGE GUIDE_X_LANGUAGE GUIDE_X_LANGUAGE GUIDE_X_LANGUAGE->LANGUAGE COUNTRY_X_LANGUAGE COUNTRY_X_LANGUAGE COUNTRY_X_LANGUAGE->LANGUAGE
column type nullable pkey defaulted referred refer
ID BIGINT
[COUNTRY_X_LANGUAGE] LANGUAGE_ID
[GUIDE_X_LANGUAGE] LANGUAGE_ID
NAME VARCHAR (2048)
SORT_NAME VARCHAR (100)
unique key columns description
CONSTRAINT_C ID
LANGUAGE_SORT_NAME_KEY SORT_NAME
column description
ID table identifier
NAME name of language
SORT_NAME name of language for sorting

LOCATION_CITYreal city

LOCATION_CITY LOCATION_CITY LOCATION_CITY LOCATION_STATE LOCATION_STATE LOCATION_CITY->LOCATION_STATE PRODUCT_X_CITY PRODUCT_X_CITY PRODUCT_X_CITY->LOCATION_CITY GUIDE GUIDE GUIDE->LOCATION_CITY
column type nullable pkey defaulted referred refer
ID BIGINT
[GUIDE] RESIDENTIAL_CITY_ID
[PRODUCT_X_CITY] CITY_ID
STATE_ID BIGINT
NAME VARCHAR (100)
LATITUDE DOUBLE
LONGITUDE DOUBLE
unique key columns description
CONSTRAINT_50 ID
LOCATION_CITY_STATE_ID_NAME_KEY STATE_IDNAME
LOCATION_CITY_LATITUDE_LONGITUDE_KEY LATITUDELONGITUDE
column description
ID table identifier
STATE_ID reference state
NAME name of city
LATITUDE latitude of city
LONGITUDE longitude of city

LOCATION_COUNTRYreal country

LOCATION_COUNTRY LOCATION_COUNTRY LOCATION_COUNTRY PRODUCT_RESERVATION PRODUCT_RESERVATION PRODUCT_RESERVATION->LOCATION_COUNTRY COUNTRY_X_LANGUAGE COUNTRY_X_LANGUAGE COUNTRY_X_LANGUAGE->LOCATION_COUNTRY LOCATION_STATE LOCATION_STATE LOCATION_STATE->LOCATION_COUNTRY user user user->LOCATION_COUNTRY
column type nullable pkey defaulted referred refer
ID BIGINT
[COUNTRY_X_LANGUAGE] COUNTRY_ID
[LOCATION_STATE] COUNTRY_ID
[PRODUCT_RESERVATION] MOBILE_COUNTRY_ID
[user] MOBILE_COUNTRY_ID
[user] NATIONALITY_ID
NAME VARCHAR (100)
SORT_NAME VARCHAR (10)
KOREAN_NAME VARCHAR (100)
COUNTRY_CODE INTEGER
LATITUDE DOUBLE
LONGITUDE DOUBLE
unique key columns description
CONSTRAINT_D ID
LOCATION_COUNTRY_NAME_KEY NAME
LOCATION_COUNTRY_SORT_NAME_KEY SORT_NAME
LOCATION_COUNTRY_LATITUDE_LONGITUDE_KEY LATITUDELONGITUDE
column description
ID table identifier
NAME name of country
SORT_NAME name of country for sorting
KOREAN_NAME korean name of country
COUNTRY_CODE international dialling code
LATITUDE latitude of country
LONGITUDE longitude of country

LOCATION_STATEreal state

LOCATION_STATE LOCATION_STATE LOCATION_STATE LOCATION_COUNTRY LOCATION_COUNTRY LOCATION_STATE->LOCATION_COUNTRY LOCATION_CITY LOCATION_CITY LOCATION_CITY->LOCATION_STATE
column type nullable pkey defaulted referred refer
ID BIGINT
[LOCATION_CITY] STATE_ID
COUNTRY_ID BIGINT
NAME VARCHAR (100)
LATITUDE DOUBLE
LONGITUDE DOUBLE
unique key columns description
CONSTRAINT_B ID
LOCATION_STATE_COUNTRY_ID_NAME_KEY COUNTRY_IDNAME
LOCATION_STATE_LATITUDE_LONGITUDE_KEY LATITUDELONGITUDE
column description
ID table identifier
COUNTRY_ID reference country
NAME name of state
LATITUDE latitude of state
LONGITUDE longitude of state

MESSAGEmessage form user to user

MESSAGE MESSAGE MESSAGE MESSAGE->MESSAGE TOUR_PLAN TOUR_PLAN MESSAGE->TOUR_PLAN user user MESSAGE->user
column type nullable pkey defaulted referred refer
ID BIGINT
[MESSAGE] REF_ID
REF_ID BIGINT
SENDER_ID BIGINT
RECEIVER_ID BIGINT
MESSAGE_HEADER VARCHAR (1024)
MESSAGE_BODY VARCHAR (2048)
MESSAGE_FOOTER VARCHAR (1024)
READ BOOLEAN
SENDER_DELETED BOOLEAN
RECEIVER_DELETED BOOLEAN
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
TAG ENUM
TOUR_PLAN_ID BIGINT
unique key columns description
CONSTRAINT_6 ID
column description
ID table identifier
REF_ID represented message
SENDER_ID reference sender
RECEIVER_ID reference receiver
MESSAGE_HEADER header content of message
MESSAGE_BODY body content of message
MESSAGE_FOOTER footer content of message
READ read message by receiver
SENDER_DELETED deleted message by sender
RECEIVER_DELETED deleted message by receiver
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted
TAG for classification
TOUR_PLAN_ID reference tour-plan

NOTICEnotify user(tourist/guide/guide manager) by administrator

NOTICE NOTICE NOTICE user user NOTICE->user
column type nullable pkey defaulted referred refer
ID BIGINT
USER_ID BIGINT
TITLE CLOB (2147483647)
DESCRIPTION CLOB (2147483647)
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_89 ID
column description
ID table identifier
USER_ID reference writer
TITLE title
DESCRIPTION description
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

PRODUCTselling product by guide or guide manager

PRODUCT PRODUCT PRODUCT CURRENCY CURRENCY PRODUCT->CURRENCY PRODUCT_EVENT_TYPE PRODUCT_EVENT_TYPE PRODUCT->PRODUCT_EVENT_TYPE user user PRODUCT->user PRODUCT_RESERVATION PRODUCT_RESERVATION PRODUCT_RESERVATION->PRODUCT PRODUCT_IMPOSSIBLE_DATE PRODUCT_IMPOSSIBLE_DATE PRODUCT_IMPOSSIBLE_DATE->PRODUCT PRODUCT_PRICE PRODUCT_PRICE PRODUCT_PRICE->PRODUCT PRODUCT_X_CITY PRODUCT_X_CITY PRODUCT_X_CITY->PRODUCT PRODUCT_X_THEME PRODUCT_X_THEME PRODUCT_X_THEME->PRODUCT SERVICE SERVICE SERVICE->PRODUCT USER_X_INTEREST_PRODUCT USER_X_INTEREST_PRODUCT USER_X_INTEREST_PRODUCT->PRODUCT PRODUCT_X_KEYWORD PRODUCT_X_KEYWORD PRODUCT_X_KEYWORD->PRODUCT TOUR TOUR TOUR->PRODUCT
column type nullable pkey defaulted referred refer
ID BIGINT
[PRODUCT_IMPOSSIBLE_DATE] PRODUCT_ID
[PRODUCT_PRICE] PRODUCT_ID
[PRODUCT_RESERVATION] PRODUCT_ID
[PRODUCT_X_CITY] PRODUCT_ID
[PRODUCT_X_KEYWORD] PRODUCT_ID
[PRODUCT_X_THEME] PRODUCT_ID
[SERVICE] ID
[TOUR] ID
[USER_X_INTEREST_PRODUCT] PRODUCT_ID
TITLE VARCHAR (100)
STATUS ENUM
PRODUCT_EVENT_TYPE_ID BIGINT
SELLER_ID BIGINT
CURRENCY_ID BIGINT
IMAGE_ID BIGINT
SUMMARY CLOB (2147483647)
DESCRIPTION CLOB (2147483647)
INCLUSION CLOB (2147483647)
EXCLUSION CLOB (2147483647)
ETC CLOB (2147483647)
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
UNLOAD VARCHAR (1000)
TYPE ENUM
unique key columns description
CONSTRAINT_18 ID
column description
ID table identifier
TITLE title of product
STATUS approved by administrator
PRODUCT_EVENT_TYPE_ID promotion about product
SELLER_ID reference seller
CURRENCY_ID base currency
IMAGE_ID representative image of product
SUMMARY summary of product
DESCRIPTION description
INCLUSION extra options what are include in the price
EXCLUSION extra options what are not include in the price
ETC extra description
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted
UNLOAD request message for stop sale product
TYPE product type(tour/service)

PRODUCT_EVENT_TYPEdefine promotion type about product

PRODUCT_EVENT_TYPE PRODUCT_EVENT_TYPE PRODUCT_EVENT_TYPE PRODUCT PRODUCT PRODUCT->PRODUCT_EVENT_TYPE
column type nullable pkey defaulted referred refer
ID BIGINT
[PRODUCT] PRODUCT_EVENT_TYPE_ID
NAME VARCHAR (255)
DISCOUNT INTEGER
MARKER VARCHAR (2048)
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_49B ID
PRODUCT_EVENT_TYPE_NAME_KEY NAME
column description
ID table identifier
NAME name of promotion
DISCOUNT discount rate(0 ~ 99)
MARKER mark as
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

PRODUCT_IMPOSSIBLE_DATEimpossible date to reserve a product

PRODUCT_IMPOSSIBLE_DATE PRODUCT_IMPOSSIBLE_DATE PRODUCT_IMPOSSIBLE_DATE PRODUCT PRODUCT PRODUCT_IMPOSSIBLE_DATE->PRODUCT
column type nullable pkey defaulted referred refer
PRODUCT_ID BIGINT
DATE DATE
unique key columns description
PRODUCT_IMPOSSIBLE_DATE_PKEY PRODUCT_IDDATE
column description
PRODUCT_ID reference product
DATE impossible date

PRODUCT_PRICEprice information of product. price of one product is comprised one price information or more.

PRODUCT_PRICE PRODUCT_PRICE PRODUCT_PRICE PRODUCT PRODUCT PRODUCT_PRICE->PRODUCT
column type nullable pkey defaulted referred refer
ID BIGINT
PRODUCT_ID BIGINT
MINIMUM_PEOPLE INTEGER
MAXIMUM_PEOPLE INTEGER
PRICE DOUBLE
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_42 ID
PRODUCT_PRICE_PRODUCT_ID_MINIMUM_PEOPLE_MAXIMUM_PEOPLE_KEY PRODUCT_IDMINIMUM_PEOPLEMAXIMUM_PEOPLE
column description
ID table identifier
PRODUCT_ID reference product
MINIMUM_PEOPLE minimum number of people is affected by this price information
MAXIMUM_PEOPLE maximum number of people is affected by this price information
PRICE price
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

PRODUCT_RESERVATIONreservation of product

PRODUCT_RESERVATION PRODUCT_RESERVATION PRODUCT_RESERVATION CURRENCY CURRENCY PRODUCT_RESERVATION->CURRENCY PRODUCT PRODUCT PRODUCT_RESERVATION->PRODUCT LOCATION_COUNTRY LOCATION_COUNTRY PRODUCT_RESERVATION->LOCATION_COUNTRY THEME THEME PRODUCT_RESERVATION->THEME user user PRODUCT_RESERVATION->user CONFIRMATION CONFIRMATION CONFIRMATION->PRODUCT_RESERVATION
column type nullable pkey defaulted referred refer
ID BIGINT
[CONFIRMATION] ID
USER_ID BIGINT
PRODUCT_ID BIGINT
CURRENCY_ID BIGINT
BOOK_DATE DATE
NUMBER_PEOPLE INTEGER
AGE ENUM
PURPOSE_ID BIGINT
REQUEST_MESSAGE CLOB (2147483647)
STATUS ENUM
NAME VARCHAR (100)
ENGLISH_NAME VARCHAR (100)
MOBILE_COUNTRY_ID BIGINT
MOBILE VARCHAR (20)
EMAIL VARCHAR (100)
PAYOUT_STATUS ENUM
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
EVENT_NAME VARCHAR (255)
EVENT_DISCOUNT INTEGER
ORIGINAL_PRICE DOUBLE
FINAL_PRICE DOUBLE
EPILOGUE_STAR_POINT INTEGER
EPILOGUE_COMMENT CLOB (2147483647)
EPILOGUE_WROTE_AT TIMESTAMP
EPILOGUE_REPLY CLOB (2147483647)
unique key columns description
CONSTRAINT_3F ID
column description
ID table identifier
USER_ID reference people who has booked
PRODUCT_ID reference product
CURRENCY_ID reference currency
BOOK_DATE booked date
NUMBER_PEOPLE number of people
AGE age of representative
PURPOSE_ID purpose of tour. reference trend theme.
REQUEST_MESSAGE request message about tour
STATUS tour progress situation
NAME name of representative
ENGLISH_NAME english name of representative
MOBILE_COUNTRY_ID reference activated country of cellphone
MOBILE mobile number of representative
EMAIL email of representative
PAYOUT_STATUS is paid
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted
EVENT_NAME promotion about product
EVENT_DISCOUNT promotion about product
ORIGINAL_PRICE non-discounted price by event
FINAL_PRICE discounted price by event
EPILOGUE_STAR_POINT score (0 ~ 5) about tour satisfaction
EPILOGUE_COMMENT comment of epilogue
EPILOGUE_WROTE_AT timestamp when this epilogue is wrote

PRODUCT_X_CITYrelationship of product with city. tour city is one or more.

PRODUCT_X_CITY PRODUCT_X_CITY PRODUCT_X_CITY PRODUCT PRODUCT PRODUCT_X_CITY->PRODUCT LOCATION_CITY LOCATION_CITY PRODUCT_X_CITY->LOCATION_CITY
column type nullable pkey defaulted referred refer
ID BIGINT
PRODUCT_ID BIGINT
CITY_ID BIGINT
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_24 ID
PRODUCT_X_CITY_PRODUCT_ID_CITY_ID_KEY PRODUCT_IDCITY_ID
column description
ID table identifier
PRODUCT_ID reference product
CITY_ID reference city
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

PRODUCT_X_KEYWORDrelationship of product with keyword.

PRODUCT_X_KEYWORD PRODUCT_X_KEYWORD PRODUCT_X_KEYWORD PRODUCT PRODUCT PRODUCT_X_KEYWORD->PRODUCT KEYWORD KEYWORD PRODUCT_X_KEYWORD->KEYWORD
column type nullable pkey defaulted referred refer
ID BIGINT
PRODUCT_ID BIGINT
KEYWORD_ID BIGINT
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_65 ID
column description
ID table identifier
PRODUCT_ID reference product
KEYWORD_ID reference keyword
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

PRODUCT_X_THEMErelationship of product with theme

PRODUCT_X_THEME PRODUCT_X_THEME PRODUCT_X_THEME PRODUCT PRODUCT PRODUCT_X_THEME->PRODUCT THEME THEME PRODUCT_X_THEME->THEME
column type nullable pkey defaulted referred refer
ID BIGINT
PRODUCT_ID BIGINT
THEME_ID BIGINT
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_7B ID
column description
ID table identifier
PRODUCT_ID reference product
THEME_ID reference theme
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

PUBLIC_FILEsaved file at server

PUBLIC_FILE PUBLIC_FILE PUBLIC_FILE TOUR_SCHEDULE_NODE_MEDIA_FILE TOUR_SCHEDULE_NODE_MEDIA_FILE TOUR_SCHEDULE_NODE_MEDIA_FILE->PUBLIC_FILE GUIDE_X_LICENSE GUIDE_X_LICENSE GUIDE_X_LICENSE->PUBLIC_FILE THEME THEME THEME->PUBLIC_FILE COURSE_X_MEDIA_FILE COURSE_X_MEDIA_FILE COURSE_X_MEDIA_FILE->PUBLIC_FILE user user user->PUBLIC_FILE
column type nullable pkey defaulted referred refer
ID BIGINT
[GUIDE_X_LICENSE] LICENSE_PICTURE_FILE_ID
[COURSE_X_MEDIA_FILE] PUBLIC_FILE_ID
[THEME] BACKGROUND_IMAGE_ID
[THEME] IMAGE_ID
[TOUR_SCHEDULE_NODE_MEDIA_FILE] PUBLIC_FILE_ID
[user] PROFILE_IMAGE_ID
ORIGINAL_NAME VARCHAR (256)
NAME VARCHAR (256)
SIZE BIGINT
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_4 ID
column description
ID table identifier
ORIGINAL_NAME file name what is file name of user end side in uploading
NAME saved file name at server side after upload
SIZE file size
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

SELLER_IMPOSSIBLE_DATEimpossible date to reserve a product what is sale by seller

SELLER_IMPOSSIBLE_DATE SELLER_IMPOSSIBLE_DATE SELLER_IMPOSSIBLE_DATE GUIDE GUIDE SELLER_IMPOSSIBLE_DATE->GUIDE
column type nullable pkey defaulted referred refer
SELLER_ID BIGINT
DATE DATE
unique key columns description
SELLER_IMPOSSIBLE_DATE_PKEY SELLER_IDDATE
column description
SELLER_ID reference seller
DATE impossible date

SERVICEdefine service for service provide by guide or guide manager

SERVICE SERVICE SERVICE PRODUCT PRODUCT SERVICE->PRODUCT SERVICE_TYPE SERVICE_TYPE SERVICE->SERVICE_TYPE
column type nullable pkey defaulted referred refer
ID BIGINT
SERVICE_TYPE_ID BIGINT
TRANSPORTATION_TYPE ENUM
unique key columns description
CONSTRAINT_A10 ID
column description
ID table identifier
SERVICE_TYPE_ID representative service type
TRANSPORTATION_TYPE kind of transportation in the service

SERVICE_TYPEdefine service type for service provide by guide or guide manager

SERVICE_TYPE SERVICE_TYPE SERVICE_TYPE SERVICE SERVICE SERVICE->SERVICE_TYPE
column type nullable pkey defaulted referred refer
ID BIGINT
[SERVICE] SERVICE_TYPE_ID
NAME VARCHAR (2048)
unique key columns description
CONSTRAINT_A1 ID
SERVICE_TYPE_NAME_KEY NAME
column description
ID table identifier
NAME name of service type

THEMEdefine theme

THEME THEME THEME THEME->THEME PUBLIC_FILE PUBLIC_FILE THEME->PUBLIC_FILE PRODUCT_RESERVATION PRODUCT_RESERVATION PRODUCT_RESERVATION->THEME PRODUCT_X_THEME PRODUCT_X_THEME PRODUCT_X_THEME->THEME TOUR_PLAN_X_THEME TOUR_PLAN_X_THEME TOUR_PLAN_X_THEME->THEME
column type nullable pkey defaulted referred refer
ID BIGINT
[PRODUCT_RESERVATION] PURPOSE_ID
[PRODUCT_X_THEME] THEME_ID
[THEME] REF_ID
[TOUR_PLAN_X_THEME] THEME_ID
NAME VARCHAR (2048)
REF_ID BIGINT
TREND BOOLEAN
IMAGE_ID BIGINT
BACKGROUND_IMAGE_ID BIGINT
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_4C ID
column description
ID table identifier
NAME name of theme
REF_ID reference anyone of "theme"
TREND is representative
IMAGE_ID reference icon
BACKGROUND_IMAGE_ID reference picture
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

TOURselling tour-product by guide or guide manager

TOUR TOUR TOUR PRODUCT PRODUCT TOUR->PRODUCT CUSTOM_TOUR CUSTOM_TOUR CUSTOM_TOUR->TOUR UNIT_TOUR UNIT_TOUR UNIT_TOUR->TOUR
column type nullable pkey defaulted referred refer
ID BIGINT
[CUSTOM_TOUR] ID
[UNIT_TOUR] ID
TYPE ENUM
ADJUSTABLE_TIME BOOLEAN
MUST_INQUIRE BOOLEAN
TOUR_SCALE ENUM
DUE_DATE_TYPE ENUM
DUE_DATE DOUBLE
unique key columns description
CONSTRAINT_27 ID
column description
ID table identifier
TYPE tour type(unit tour/custom tour)
ADJUSTABLE_TIME is adjustable when meet with guide
MUST_INQUIRE must inquire, before reserve
TOUR_SCALE tour type(independent travel/associated travel)
DUE_DATE_TYPE unit about period of trip
DUE_DATE period of trip

TOURISTuser of tourist type

TOURIST TOURIST TOURIST user user TOURIST->user TOURIST_FACEBOOK TOURIST_FACEBOOK TOURIST_FACEBOOK->TOURIST TOURIST_TWITTER TOURIST_TWITTER TOURIST_TWITTER->TOURIST TOURIST_GOOGLEPLUS TOURIST_GOOGLEPLUS TOURIST_GOOGLEPLUS->TOURIST TOURIST_EMAIL TOURIST_EMAIL TOURIST_EMAIL->TOURIST TOURIST_KAKAOTALK TOURIST_KAKAOTALK TOURIST_KAKAOTALK->TOURIST
column type nullable pkey defaulted referred refer
ID BIGINT
[TOURIST_EMAIL] ID
[TOURIST_FACEBOOK] ID
[TOURIST_GOOGLEPLUS] ID
[TOURIST_KAKAOTALK] ID
[TOURIST_TWITTER] ID
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_E ID
column description
ID table identifier
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

TOURIST_EMAILjoined tourist through input email information

TOURIST_EMAIL TOURIST_EMAIL TOURIST_EMAIL TOURIST TOURIST TOURIST_EMAIL->TOURIST
column type nullable pkey defaulted referred refer
ID BIGINT
EMAIL VARCHAR (100)
PASSWORD VARCHAR (100)
GENERATE_KEY VARCHAR (255)
CERTIFIED_AT TIMESTAMP
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_496 ID
TOURIST_EMAIL_EMAIL_KEY EMAIL
column description
ID table identifier
EMAIL email of tourist. login ID
PASSWORD login password
GENERATE_KEY generated key for certificating email
CERTIFIED_AT timestamp when email is certificated
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

TOURIST_FACEBOOKjoined tourist through facebook

TOURIST_FACEBOOK TOURIST_FACEBOOK TOURIST_FACEBOOK TOURIST TOURIST TOURIST_FACEBOOK->TOURIST
column type nullable pkey defaulted referred refer
ID BIGINT
SOCIAL_ID VARCHAR (255)
FIRST_NAME VARCHAR (100)
MIDDLE_NAME VARCHAR (100)
LAST_NAME VARCHAR (100)
EMAIL VARCHAR (255)
GENDER ENUM
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_1 ID
TOURIST_FACEBOOK_SOCIAL_ID_KEY SOCIAL_ID
column description
ID table identifier
SOCIAL_ID facebook ID. login ID
FIRST_NAME first name of tourist that is received from facebook
MIDDLE_NAME middle name of tourist that is received from facebook
LAST_NAME last name of tourist that is received from facebook
EMAIL email of tourist that is received from facebook
GENDER gender of tourist that is received from facebook
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

TOURIST_GOOGLEPLUSjoined tourist through googleplus

TOURIST_GOOGLEPLUS TOURIST_GOOGLEPLUS TOURIST_GOOGLEPLUS TOURIST TOURIST TOURIST_GOOGLEPLUS->TOURIST
column type nullable pkey defaulted referred refer
ID BIGINT
SOCIAL_ID VARCHAR (255)
FULL_NAME VARCHAR (255)
FIRST_NAME VARCHAR (100)
LAST_NAME VARCHAR (100)
EMAIL VARCHAR (255)
GENDER ENUM
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_57 ID
TOURIST_GOOGLEPLUS_SOCIAL_ID_KEY SOCIAL_ID
column description
ID table identifier
SOCIAL_ID googleplus ID. login ID
FULL_NAME full name of tourist that is received from googleplus
FIRST_NAME first name of tourist that is received from googleplus
LAST_NAME last name of tourist that is received from googleplus
EMAIL email of tourist that is received from googleplus
GENDER gender of tourist that is received from googleplus
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

TOURIST_KAKAOTALKjoined tourist through kakaotalk

TOURIST_KAKAOTALK TOURIST_KAKAOTALK TOURIST_KAKAOTALK TOURIST TOURIST TOURIST_KAKAOTALK->TOURIST
column type nullable pkey defaulted referred refer
ID BIGINT
SOCIAL_ID VARCHAR (255)
NICKNAME VARCHAR (255)
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_9 ID
TOURIST_KAKAOTALK_SOCIAL_ID_KEY SOCIAL_ID
column description
ID table identifier
SOCIAL_ID kakaotalk ID. login ID
NICKNAME nickname of tourist that is received from kakaotalk
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

TOURIST_TWITTERjoined tourist through twitter

TOURIST_TWITTER TOURIST_TWITTER TOURIST_TWITTER TOURIST TOURIST TOURIST_TWITTER->TOURIST
column type nullable pkey defaulted referred refer
ID BIGINT
SOCIAL_ID VARCHAR (255)
SCREEN_NAME VARCHAR (255)
NAME VARCHAR (255)
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_A ID
TOURIST_TWITTER_SOCIAL_ID_KEY SOCIAL_ID
column description
ID table identifier
SOCIAL_ID twitter ID. login ID
SCREEN_NAME screen-name of tourist that is received from twitter
NAME name of tourist that is received from twitter
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

TOUR_PLANplan tour by user. also it is used component of custom tour.

TOUR_PLAN TOUR_PLAN TOUR_PLAN user user TOUR_PLAN->user MESSAGE MESSAGE MESSAGE->TOUR_PLAN TOUR_SKETCH TOUR_SKETCH TOUR_SKETCH->TOUR_PLAN CUSTOM_TOUR CUSTOM_TOUR CUSTOM_TOUR->TOUR_PLAN TOUR_SCHEDULE TOUR_SCHEDULE TOUR_SCHEDULE->TOUR_PLAN TOUR_PLAN_X_THEME TOUR_PLAN_X_THEME TOUR_PLAN_X_THEME->TOUR_PLAN
column type nullable pkey defaulted referred refer
ID BIGINT
[CUSTOM_TOUR] TOUR_PLAN_ID
[MESSAGE] TOUR_PLAN_ID
[TOUR_PLAN_X_THEME] TOUR_PLAN_ID
[TOUR_SCHEDULE] TOUR_PLAN_ID
[TOUR_SKETCH] ID
USER_ID BIGINT
TITLE VARCHAR (200)
DESCRIPTION CLOB (2147483647)
START_AT DATE
END_AT DATE
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_D6 ID
column description
ID table identifier
USER_ID reference writer
TITLE title of tour-plan
DESCRIPTION description
START_AT start date of tour
END_AT end date of tour
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

TOUR_PLAN_X_THEMErelationship of tour-plan with theme

TOUR_PLAN_X_THEME TOUR_PLAN_X_THEME TOUR_PLAN_X_THEME TOUR_PLAN TOUR_PLAN TOUR_PLAN_X_THEME->TOUR_PLAN THEME THEME TOUR_PLAN_X_THEME->THEME
column type nullable pkey defaulted referred refer
ID BIGINT
TOUR_PLAN_ID BIGINT
THEME_ID BIGINT
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_F6 ID
TOUR_PLAN_X_THEME_TOUR_PLAN_ID_THEME_ID_KEY TOUR_PLAN_IDTHEME_ID
column description
ID table identifier
TOUR_PLAN_ID reference tour-plan
THEME_ID reference theme
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

TOUR_SCHEDULEschedule sheet of tour-plan

TOUR_SCHEDULE TOUR_SCHEDULE TOUR_SCHEDULE TOUR_PLAN TOUR_PLAN TOUR_SCHEDULE->TOUR_PLAN TOUR_SCHEDULE_DAY TOUR_SCHEDULE_DAY TOUR_SCHEDULE_DAY->TOUR_SCHEDULE
column type nullable pkey defaulted referred refer
ID BIGINT
[TOUR_SCHEDULE_DAY] TOUR_SCHEDULE_ID
TOUR_PLAN_ID BIGINT
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_5C ID
column description
ID table identifier
TOUR_PLAN_ID reference tour-plan
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

TOUR_SCHEDULE_DAYinformation about specific day in tour-plan. they are sequential about time.

TOUR_SCHEDULE_DAY TOUR_SCHEDULE_DAY TOUR_SCHEDULE_DAY TOUR_SCHEDULE TOUR_SCHEDULE TOUR_SCHEDULE_DAY->TOUR_SCHEDULE TOUR_SCHEDULE_NODE TOUR_SCHEDULE_NODE TOUR_SCHEDULE_NODE->TOUR_SCHEDULE_DAY
column type nullable pkey defaulted referred refer
ID BIGINT
[TOUR_SCHEDULE_NODE] TOUR_SCHEDULE_DAY_ID
TOUR_SCHEDULE_ID BIGINT
SEQUENCE INTEGER
TITLE VARCHAR (100)
DESCRIPTION CLOB (2147483647)
TRANSPORTATION_TYPE ENUM
MEETING_TIME VARCHAR (100)
MEETING_LOCATION_NAME VARCHAR (50)
MEETING_LOCATION_MAP_ZOOM INTEGER
MEETING_LOCATION_LATITUDE DOUBLE
MEETING_LOCATION_LONGITUDE DOUBLE
MEETING_LOCATION_DESCRIPTION CLOB (2147483647)
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_94 ID
column description
ID table identifier
TOUR_SCHEDULE_ID reference tour-schedule
SEQUENCE sequence number
TITLE title
DESCRIPTION description
TRANSPORTATION_TYPE kind of transportation in the day
MEETING_TIME when meet with guide
MEETING_LOCATION_NAME name of place where meet with guide
MEETING_LOCATION_MAP_ZOOM zoom level of google map about place where meet with guide
MEETING_LOCATION_LATITUDE latitude of place where meet with guide
MEETING_LOCATION_LONGITUDE longitude of place where meet with guide
MEETING_LOCATION_DESCRIPTION description about place where meet with guide
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

TOUR_SCHEDULE_NODEinformation about course in specific tour day. detailed information about course is reference "product_course" entity.

TOUR_SCHEDULE_NODE TOUR_SCHEDULE_NODE TOUR_SCHEDULE_NODE TOUR_SCHEDULE_DAY TOUR_SCHEDULE_DAY TOUR_SCHEDULE_NODE->TOUR_SCHEDULE_DAY COURSE COURSE TOUR_SCHEDULE_NODE->COURSE TOUR_SCHEDULE_NODE_MEDIA_FILE TOUR_SCHEDULE_NODE_MEDIA_FILE TOUR_SCHEDULE_NODE_MEDIA_FILE->TOUR_SCHEDULE_NODE
column type nullable pkey defaulted referred refer
ID BIGINT
[TOUR_SCHEDULE_NODE_MEDIA_FILE] TOUR_SCHEDULE_NODE_ID
TOUR_SCHEDULE_DAY_ID BIGINT
COURSE_ID BIGINT
START INTEGER
SIZE INTEGER
TITLE VARCHAR (100)
DESCRIPTION CLOB (2147483647)
LATITUDE DOUBLE
LONGITUDE DOUBLE
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
unique key columns description
CONSTRAINT_2C ID
column description
ID table identifier
TOUR_SCHEDULE_DAY_ID reference tour-schedule-day
COURSE_ID reference course
START start time. unit is minute. "0" is mean twelve at night.
SIZE period time about course. unit is minute.
TITLE title
DESCRIPTION description
LATITUDE latitude of course
LONGITUDE longitude of course
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted

TOUR_SCHEDULE_NODE_MEDIA_FILEimage file what is comprised in one tour-schedule-node

TOUR_SCHEDULE_NODE_MEDIA_FILE TOUR_SCHEDULE_NODE_MEDIA_FILE TOUR_SCHEDULE_NODE_MEDIA_FILE TOUR_SCHEDULE_NODE TOUR_SCHEDULE_NODE TOUR_SCHEDULE_NODE_MEDIA_FILE->TOUR_SCHEDULE_NODE PUBLIC_FILE PUBLIC_FILE TOUR_SCHEDULE_NODE_MEDIA_FILE->PUBLIC_FILE
column type nullable pkey defaulted referred refer
ID BIGINT
TOUR_SCHEDULE_NODE_ID BIGINT
PUBLIC_FILE_ID BIGINT
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_DA6 ID
column description
ID table identifier
TOUR_SCHEDULE_NODE_ID reference tour-schedule-node
PUBLIC_FILE_ID reference image file
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

TOUR_SKETCHcollection tour-information

TOUR_SKETCH TOUR_SKETCH TOUR_SKETCH TOUR_PLAN TOUR_PLAN TOUR_SKETCH->TOUR_PLAN TOUR_SKETCH_NODE TOUR_SKETCH_NODE TOUR_SKETCH_NODE->TOUR_SKETCH
column type nullable pkey defaulted referred refer
ID BIGINT
[TOUR_SKETCH_NODE] TOUR_SKETCH_ID
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_F1 ID
column description
ID table identifier
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

TOUR_SKETCH_NODEtour-information

TOUR_SKETCH_NODE TOUR_SKETCH_NODE TOUR_SKETCH_NODE TOUR_SKETCH_NODE->TOUR_SKETCH_NODE TOUR_SKETCH TOUR_SKETCH TOUR_SKETCH_NODE->TOUR_SKETCH UNIT_TOUR UNIT_TOUR TOUR_SKETCH_NODE->UNIT_TOUR
column type nullable pkey defaulted referred refer
ID BIGINT
[TOUR_SKETCH_NODE] REF_ID
TOUR_SKETCH_ID BIGINT
SEQUENCE DOUBLE
NAME VARCHAR (200)
REF_ID BIGINT
TYPE ENUM
UNIT_TOUR_ID BIGINT
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_3A ID
column description
ID table identifier
TOUR_SKETCH_ID reference tour-sketch
SEQUENCE sequence number
NAME name of information
REF_ID reference tour-sketch-node
TYPE tour-sketch-node is two types: folder(no information. for classification), item(belong folder-node)
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

UNIT_TOURselling tour-product by guide

UNIT_TOUR UNIT_TOUR UNIT_TOUR TOUR TOUR UNIT_TOUR->TOUR TOUR_SKETCH_NODE TOUR_SKETCH_NODE TOUR_SKETCH_NODE->UNIT_TOUR COURSE COURSE COURSE->UNIT_TOUR
column type nullable pkey defaulted referred refer
ID BIGINT
[COURSE] UNIT_TOUR_ID
[TOUR_SKETCH_NODE] UNIT_TOUR_ID
TRANSPORTATION_TYPE ENUM
MEETING_TIME VARCHAR (100)
MEETING_LOCATION_NAME VARCHAR (50)
MEETING_LOCATION_MAP_ZOOM INTEGER
MEETING_LOCATION_LATITUDE DOUBLE
MEETING_LOCATION_LONGITUDE DOUBLE
MEETING_LOCATION_DESCRIPTION CLOB (2147483647)
unique key columns description
CONSTRAINT_8B ID
column description
ID table identifier
TRANSPORTATION_TYPE kind of transportation in the trip
MEETING_TIME when meet with guide
MEETING_LOCATION_NAME name of place where meet with guide
MEETING_LOCATION_MAP_ZOOM zoom level of google map about place where meet with guide
MEETING_LOCATION_LATITUDE latitude of place where meet with guide
MEETING_LOCATION_LONGITUDE longitude of place where meet with guide
MEETING_LOCATION_DESCRIPTION description about place where meet with guide

USER_X_INTEREST_GUIDErelationship of user with guide.

USER_X_INTEREST_GUIDE USER_X_INTEREST_GUIDE USER_X_INTEREST_GUIDE GUIDE GUIDE USER_X_INTEREST_GUIDE->GUIDE user user USER_X_INTEREST_GUIDE->user
column type nullable pkey defaulted referred refer
ID BIGINT
USER_ID BIGINT
GUIDE_ID BIGINT
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_2 ID
USER_X_INTEREST_GUIDE_USER_ID_GUIDE_ID_KEY USER_IDGUIDE_ID
column description
ID table identifier
USER_ID reference user
GUIDE_ID reference guide
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

USER_X_INTEREST_PRODUCTrelationship of user with product.

USER_X_INTEREST_PRODUCT USER_X_INTEREST_PRODUCT USER_X_INTEREST_PRODUCT PRODUCT PRODUCT USER_X_INTEREST_PRODUCT->PRODUCT user user USER_X_INTEREST_PRODUCT->user
column type nullable pkey defaulted referred refer
ID BIGINT
USER_ID BIGINT
PRODUCT_ID BIGINT
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
unique key columns description
CONSTRAINT_DB ID
USER_X_INTEREST_PRODUCT_USER_ID_PRODUCT_ID_KEY USER_IDPRODUCT_ID
column description
ID table identifier
USER_ID reference user
PRODUCT_ID reference product
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated

user

user user user LOCATION_COUNTRY LOCATION_COUNTRY user->LOCATION_COUNTRY PUBLIC_FILE PUBLIC_FILE user->PUBLIC_FILE PRODUCT_RESERVATION PRODUCT_RESERVATION PRODUCT_RESERVATION->user TOUR_PLAN TOUR_PLAN TOUR_PLAN->user MESSAGE MESSAGE MESSAGE->user NOTICE NOTICE NOTICE->user PRODUCT PRODUCT PRODUCT->user FAQ FAQ FAQ->user USER_X_INTEREST_PRODUCT USER_X_INTEREST_PRODUCT USER_X_INTEREST_PRODUCT->user ADMIN ADMIN ADMIN->user GUIDE GUIDE GUIDE->user TOURIST TOURIST TOURIST->user USER_X_INTEREST_GUIDE USER_X_INTEREST_GUIDE USER_X_INTEREST_GUIDE->user
column type nullable pkey defaulted referred refer
ID BIGINT
[ADMIN] ID
[FAQ] USER_ID
[GUIDE] ID
[MESSAGE] RECEIVER_ID
[MESSAGE] SENDER_ID
[NOTICE] USER_ID
[PRODUCT_RESERVATION] USER_ID
[PRODUCT] SELLER_ID
[TOURIST] ID
[TOUR_PLAN] USER_ID
[USER_X_INTEREST_GUIDE] USER_ID
[USER_X_INTEREST_PRODUCT] USER_ID
TYPE ENUM
EMAIL VARCHAR (100)
FIRST_NAME VARCHAR (100)
MIDDLE_NAME VARCHAR (100)
LAST_NAME VARCHAR (100)
PROFILE_IMAGE_ID BIGINT
PROFILE_DESCRIPTION CLOB (2147483647)
GENDER ENUM
MOBILE_COUNTRY_ID BIGINT
MOBILE VARCHAR (20)
NATIONALITY_ID BIGINT
ACCOUNT_STATUS ENUM
CREATED_AT TIMESTAMP
UPDATED_AT TIMESTAMP
DELETED_AT TIMESTAMP
AGREE_RECEIVE BOOLEAN
LOCALE VARCHAR (16)
unique key columns description
CONSTRAINT_3 ID
column description
ID table identifier
CREATED_AT timestamp when this record is created
UPDATED_AT timestamp when this record is updated
DELETED_AT present that this record is deleted