trip
Tables (7)
COURSE
- COURSE_ID — BIGINT — Primary key — NOT NULL
- END_DATE — DATE
- RATED — BIT
- START_DATE — DATE
- CREATE_DATE — DATETIME(6)
- USER_ID — BIGINT — Foreign key → USER.USER_ID
- AREA — VARCHAR(255)
- MEANS_TP — VARCHAR(255)
- MODEL_NAME — VARCHAR(255)
- MODEL_TYPE — VARCHAR(255)
- PERSON — VARCHAR(255)
- TITLE — VARCHAR(255)
- TRIP_TYPE — VARCHAR(255)
COURSE_DETAILS
- COURSE_DT_ID — BIGINT — Primary key — NOT NULL
- DAY — DATE
- SEQUENCE — INTEGER
- COURSE_ID — BIGINT — Foreign key → COURSE.COURSE_ID
- PLACE_ADDRESS — VARCHAR(255)
- PLACE_LAT — VARCHAR(255)
- PLACE_LON — VARCHAR(255)
- PLACE_NAME — VARCHAR(255)
- PLACE_TYPE — VARCHAR(255)
INQUIRE
- INQUIRE_ID — BIGINT — Primary key — NOT NULL
- IS_ANSWERED — BIT
- ANSWERED_DATE — DATETIME(6)
- CREATE_DATE — DATETIME(6)
- USER_ID — BIGINT — Foreign key → USER.USER_ID
- ANSWER — TEXT
- CONTENT — TEXT
- TITLE — VARCHAR(255)
MODEL
- MODEL_ID — BIGINT — Primary key — NOT NULL
- LEARNINGRATE — FLOAT(53)
- MAXDEPTH — INTEGER
- MINSAMPLESSPLIT — INTEGER
- NESTIMATORS — INTEGER
- APPLY_DATE — DATETIME(6)
- CREATE_DATE — DATETIME(6)
- INFORMATION — TEXT
- MODEL_TYPE — VARCHAR(255)
- NAME — VARCHAR(255)
NOTICE
- NOTICE_ID — BIGINT — Primary key — NOT NULL
- CREATE_DATE — DATETIME(6)
- CONTENT — TEXT
- NOTICE_TYPE — VARCHAR(255)
- TITLE — VARCHAR(255)
RATING
- RATING_ID — BIGINT — Primary key — NOT NULL
- SCORE — FLOAT(53)
- CREATE_DATE — DATETIME(6)
- COURSE_ID — BIGINT — Foreign key → COURSE.COURSE_ID
- USER_ID — BIGINT — Foreign key → USER.USER_ID
- MODEL_NAME — VARCHAR(255)
USER
- USER_ID — BIGINT — Primary key — NOT NULL
- BIRTH — DATE
- IS_FIRST — BIT
- IS_SUSPENDED — BIT
- CREATE_DATE — DATETIME(6)
- EMAIL — VARCHAR(255)
- GENDER — VARCHAR(255)
- NAME — VARCHAR(255)
- PASSWORD — VARCHAR(255)
- ROLE — VARCHAR(255)
- USER_TRIP_TYPE — VARCHAR(255)