gd_test
Tables (26)
answer
- answer_no — int
- question_no — int — NOT NULL
- employee_id — varchar(100) — NOT NULL
- answer_content — text — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
bus
- bus_no — int — NOT NULL
- bus_driver — varchar(100) — NOT NULL
- bus_limited — int — NOT NULL
busstop
- route_no — int — Primary key — NOT NULL
- bus_stop — varchar(100) — Primary key — NOT NULL
cart
- lecture_no — int — Primary key — NOT NULL
- member_id — varchar(100) — Primary key — NOT NULL
- create_date — datetime — NOT NULL
comment
- comment_no — int
- employee_id — varchar(100) — NOT NULL
- comment_content — varchar(100) — NOT NULL
- create_date — datetime — NOT NULL
consult
- employee_id — varchar(100) — NOT NULL
- consult_no — int
- consult_content — text — NOT NULL
- create_date — datetime — NOT NULL
consultreservation
- consultReservation_no — int
- employee_id — varchar(100) — NOT NULL
- member_id — varchar(100) — NOT NULL
- consult_date — datetime — NOT NULL
- consult_phone — varchar(100) — NOT NULL
- create_date — datetime — NOT NULL
employee
- employee_id — varchar(100) — NOT NULL
- employee_pw — varchar(100) — NOT NULL
- employee_name — varchar(100) — NOT NULL
- employee_phone — varchar(50) — NOT NULL
- employee_email — varchar(100) — NOT NULL
- active — enum — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
instructor
- instructor_id — varchar(100) — NOT NULL
- instructor_pw — varchar(100) — NOT NULL
- instructor_name — varchar(100) — NOT NULL
- instructor_phone — varchar(100) — NOT NULL
- instructor_gender — varchar(10) — NOT NULL
- instructor_email — varchar(100) — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
instructorimg
- instructor_id — varchar(100) — NOT NULL
- file_name — varchar(100) — NOT NULL
- originalFile_name — varchar(100) — NOT NULL
- file_type — varchar(100) — NOT NULL
- file_size — int — NOT NULL
lecture
- lecture_no — int — NOT NULL
- instructor_id — varchar(100) — NOT NULL
- location_no — int — NOT NULL
- lecture_name — varchar(100) — NOT NULL
- lecture_limited — int — NOT NULL
- lecture_startTime — time — NOT NULL
- lecture_endTime — time — NOT NULL
- lecture_price — int — NOT NULL
- lecture_startDate — datetime — NOT NULL
- lecture_endDate — datetime — NOT NULL
- refund — enum — NOT NULL
lectureday
- lecture_day — varchar(100) — Primary key — NOT NULL
- lecture_no — int — Primary key — NOT NULL
location
- location_no — int
- lecture_addr — varchar(100) — NOT NULL
- create_date — datetime — NOT NULL
locker
- locker_no — int
- course_no — int — NOT NULL
- locker_price — int — NOT NULL
- locker_start — date — NOT NULL
- locker_end — date — NOT NULL
- refund — enum — NOT NULL
member
- member_id — varchar(100) — NOT NULL
- memeber_pw — varchar(100) — NOT NULL
- member_name — varchar(100) — NOT NULL
- member_phone — varchar(100) — NOT NULL
- member_email — varchar(100) — NOT NULL
- member_addr — varchar(100) — NOT NULL
- member_detailAddr — varchar(100) — NOT NULL
- member_birth — varchar(100) — NOT NULL
- member_gender — varchar(10) — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
memberimg
- member_id — varchar(100) — NOT NULL
- file_name — varchar(100) — NOT NULL
- originalFile_name — varchar(100) — NOT NULL
- file_type — varchar(100) — NOT NULL
- file_size — int — NOT NULL
notice
- notice_no — int
- employee_id — varchar(100) — NOT NULL
- notice_title — varchar(100) — NOT NULL
- notice_content — varchar(100) — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
noticefile
- noticeFile_no — int
- notice_no — int — NOT NULL
- file_name — varchar(100) — NOT NULL
- originalFile_name — varchar(100) — NOT NULL
- file_type — varchar(100) — NOT NULL
- file_size — int — NOT NULL
outmember
- out_id — varchar(100) — NOT NULL
- out_date — datetime — NOT NULL
payment
- course_no — int — NOT NULL
- lecture_no — int — NOT NULL
- member_id — varchar(100) — NOT NULL
- pay_method — varchar(100) — NOT NULL
- pay_date — datetime — NOT NULL
question
- question_no — int — NOT NULL
- member_id — varchar(100) — NOT NULL
- question_title — varchar(100) — NOT NULL
- question_content — text — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
race
- race_no — int
- bus_no — int — NOT NULL
- route_no — int — NOT NULL
rent
- rent_no — int
- rent_place — varchar(100) — NOT NULL
- member_id — varchar(100) — NOT NULL
- reservation_date — datetime — NOT NULL
- create_date — datetime — NOT NULL
- refund — enum — NOT NULL
rentplace
- rent_place — varchar(100) — NOT NULL
- rent_price — int — NOT NULL
- rent_limited — int — NOT NULL
review
- course_no — int — NOT NULL
- review_title — varchar(100) — NOT NULL
- review_content — varchar(100) — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
route
- route_no — int — NOT NULL
- route_start — time — NOT NULL
- route_end — time — NOT NULL
- route_interval — varchar(100) — NOT NULL