test
Tables (28)
call
- call_id — BIGINT — Primary key — NOT NULL
- call_from — VARCHAR(255)
- call_from_id — VARCHAR(255)
- call_to — VARCHAR(255)
- call_to_id — VARCHAR(255)
- call_date — DATE
- type — VARCHAR(255)
- call_ctt — LONGTEXT
card
- card_id — BIGINT — Primary key — NOT NULL
- card_owner — VARCHAR(255)
- card_owner_id — VARCHAR(255)
- card_name — VARCHAR(255)
- card_num — BIGINT
- card_amount — BIGINT
- trans_date — DATE
- memo — LONGTEXT
certification
- certi_id — BIGINT — Primary key — NOT NULL
- certi_code — VARCHAR(255)
- certi_owner — VARCHAR(255)
- certi_owner_id — VARCHAR(255)
- reg_date — DATE
- exp_date — DATE
- course_id — VARCHAR(255)
- lec_id — VARCHAR(255)
contents
- ctt_id — BIGINT — Primary key — NOT NULL
- ctt_name — VARCHAR(255)
- ctt_version — BIGINT
- ctt_owner — VARCHAR(255)
- ctt_owner_id — VARCHAR(255)
- ctt_content — LONGTEXT
- ctt_type — VARCHAR(255)
- ctt_link — VARCHAR(255)
- reg_date — DATE
- exp_date — DATE
- edit_date — DATE
coupon
- coup_id — BIGINT — Primary key — NOT NULL
- coup_amount — BIGINT
- coup_type — VARCHAR(255)
- coup_ctt — LONGTEXT
- reg_date — DATE
- exp_date — DATE
- is_use — enum('Y','N')
course
- course_id — BIGINT — Primary key — NOT NULL
- course_title — VARCHAR(255)
- course_owner — VARCHAR(255)
- course_ctt — LONGTEXT
- course_max — BIGINT
- course_price — VARCHAR(255)
- reg_date — DATE
- reg_end_date — DATE
- start_date — DATE
- end_date — DATE
- course_location — VARCHAR(255)
- is_open — enum('Y','N')
- is_use — enum('Y','N')
course_lecture
- course_id — BIGINT — Foreign key → course.course_id — NOT NULL
- lec_id — BIGINT — Foreign key → lecture.lec_id — NOT NULL
deposit
- dep_id — BIGINT — Primary key — NOT NULL
- dep_owner — VARCHAR(255)
- dep_owner_id — VARCHAR(255)
- dep_amount — BIGINT
- claim_date — DATE
- dep_date — DATE
- is_card — enum('Y','N')
- is_confirm — enum('Y','N')
- dep_bank — VARCHAR(255)
- memo — LONGTEXT
enterprise
- ent_id — BIGINT — Primary key — NOT NULL
- ent_paid_yn — enum('Y','N')
- ent_lcs — VARCHAR(255)
- ent_name — VARCHAR(255)
- ent_vip — VARCHAR(255)
- ent_type — VARCHAR(255)
- ent_tel — VARCHAR(255)
- ent_fax — VARCHAR(255)
- post_num — VARCHAR(255)
- post_addr1 — VARCHAR(255)
- post_addr2 — VARCHAR(255)
- reg_date — DATE
- exp_date — DATE
- paid_start — DATE
- paid_end — DATE
- is_paid — enum('Y','N')
- is_use — enum('Y','N')
- memo — LONGTEXT
enterprise_call
- ent_id — BIGINT — Foreign key → enterprise.ent_id — NOT NULL
- call_id — BIGINT — Foreign key → call.call_id — NOT NULL
enterprise_coupon
- ent_id — BIGINT — Foreign key → enterprise.ent_id — NOT NULL
- coup_id — BIGINT — Foreign key → coupon.coup_id — NOT NULL
enterprise_deposit
- ent_id — BIGINT — Foreign key → enterprise.ent_id — NOT NULL
- dep_id — BIGINT — Foreign key → deposit.dep_id — NOT NULL
enterprise_member
- ent_id — BIGINT — Foreign key → enterprise.ent_id — NOT NULL
- mem_id — BIGINT — Foreign key → member.mem_id — NOT NULL
exam
- test_id — BIGINT — Primary key — NOT NULL
- course_id — VARCHAR(255)
- test_title — varchar(255)
- test_ctt — LONGTEXT
- reg_date — DATE
- is_use — enum('Y','N')
exam_qna
- test_id — BIGINT — Foreign key → exam.test_id — NOT NULL
- qna_id — BIGINT — Foreign key → qna.qna_id — NOT NULL
file
- file_id — BIGINT — Primary key — NOT NULL
- file_name — VARCHAR(255)
- file_version — BIGINT
- file_type — VARCHAR(255)
- file_owner — VARCHAR(255)
- file_owner_id — VARCHAR(255)
- file_size — INT
- reg_date — DATE
lecture
- lec_id — BIGINT — Primary key — NOT NULL
- lec_name — VARCHAR(255)
- lec_kind — VARCHAR(255)
- lec_code — VARCHAR(255)
- lec_ctt — LONGTEXT
- lec_owner_id — VARCHAR(255)
- lec_owner_name — VARCHAR(255)
- reg_date — DATE
- exp_date — DATE
lecture_contents
- lec_id — BIGINT — Foreign key → lecture.lec_id — NOT NULL
- ctt_id — BIGINT — Foreign key → contents.ctt_id — NOT NULL
lecture_review
- lec_id — BIGINT — Foreign key → lecture.lec_id — NOT NULL
- review_id — BIGINT — Foreign key → review.review_id — NOT NULL
like
- like_id — BIGINT — Primary key — NOT NULL
- course_id — VARCHAR(255)
- reg_date — DATE
- is_use — enum('Y','N')
member
- mem_id — BIGINT — Primary key — NOT NULL
- mem_userid — VARCHAR(255)
- mem_pwd — VARCHAR(255)
- mem_mail — VARCHAR(255)
- mem_name — VARCHAR(255)
- mem_birth — DATE
- mem_gender — enum('M','F')
- mem_phone — VARCHAR(255)
- post_num — INT(5)
- post_addr1 — VARCHAR(255)
- post_addr2 — VARCHAR(255)
- mem_mile — BIGINT
- mem_gen — BIGINT
- is_mail — enum('Y','N')
- is_sms — enum('Y','N')
- reg_date — DATE
- exp_date — DATE
- mem_grade — INT(2)
- com_num — BIGINT
- com_name — VARCHAR(255)
- is_vip — enum('Y','N')
- car_num — VARCHAR(255)
- memo — LONGTEXT
member_card
- mem_id — BIGINT — Foreign key → member.mem_id — NOT NULL
- card_id — BIGINT — Foreign key → card.card_id — NOT NULL
member_lecture
- mem_id — BIGINT — Foreign key → member.mem_id — NOT NULL
- lec_id — BIGINT — Foreign key → lecture.lec_id — NOT NULL
member_like
- mem_id — BIGINT — Foreign key → member.mem_id — NOT NULL
- like_id — BIGINT — Foreign key → like.like_id — NOT NULL
notice
- noti_id — BIGINT — Primary key — NOT NULL
- noti_num — BIGINT — NOT NULL
- noti_title — VARCHAR(255) — NOT NULL
- noti_ctt — LONGTEXT — NOT NULL
- noti_pub_date — DATE — NOT NULL
- noti_hit — BIGINT — NOT NULL
- reg_id — VARCHAR(255) — NOT NULL
- reg_date — DATE — NOT NULL
- noti_seq — BIGINT
notice_file
- noti_id — BIGINT — Foreign key → notice.noti_id — NOT NULL
- file_id — BIGINT — Foreign key → file.file_id — NOT NULL
qna
- qna_id — BIGINT — Primary key — NOT NULL
- qna_q — VARCHAR(255)
- qna_exam1 — VARCHAR(255)
- qna_exam2 — VARCHAR(255)
- qna_exam3 — VARCHAR(255)
- qna_exam4 — VARCHAR(255)
- qna_exam5 — VARCHAR(255)
- qna_a — INT(1)
- is_use — enum('Y','N')
review
- review_id — BIGINT — Primary key — NOT NULL
- review_title — varchar(255)
- review_seq — BIGINT
- review_ctt — LONGTEXT
- review_owner — VARCHAR(255)
- review_owner_id — VARCHAR(255)
- review_pwd — VARCHAR(255)
- review_like — BIGINT
- reg_date — DATE
- exp_date — DATE