test
Tables (15)
ASSIGNMENT
- ID — BIGINT
- TITLE — VARCHAR(255) — NOT NULL
- CONTENT — VARCHAR(3000)
- COURSE_ID — BIGINT — NOT NULL
- START_TIME — DATETIME
- END_TIME — DATETIME
- CREATED_TIME — DATETIME
- DEL_YN — CHAR(1) — NOT NULL
ASSIGNMENT_OUTPUT
- ID — BIGINT
- CONTENT — VARCHAR(3000)
- ASSIGNMENT_ID — BIGINT — NOT NULL
- STUDENT_ID — BIGINT — NOT NULL
- SCORE — TINYINT
- FEEDBACK — VARCHAR(300)
- SUBMIT_DATE — DATETIME
- DEL_YN — CHAR(1) — NOT NULL
COURSE_QUESTION
- ID — BIGINT
- TITLE — VARCHAR(255) — NOT NULL
- CONTENT — VARCHAR(3000)
- COURSE_ID — BIGINT — NOT NULL
- CREATED_TIME — DATETIME
- DEL_YN — CHAR(1) — NOT NULL
COURSE_RESPONSE
- ID — BIGINT
- CONTENT — VARCHAR(3000)
- C_QUESTION_ID — BIGINT — NOT NULL
- CREATED_TIME — DATETIME
- DEL_YN — CHAR(1) — NOT NULL
FA
- id — bigint — Primary key — NOT NULL
- title — varchar(255)
- content — TEXT
- created_date — datetime
- del_yn — CHAR(1)
attendance
- id — bigint — Primary key — NOT NULL
- student_id — bigint
- lecture_id — bigint
- state — char(1)
- view_date — datetime
- del_yn — CHAR(1)
course
- id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(8000) — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- category — VARCHAR(255) — NOT NULL
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- instructor_id — BIGINT — Foreign key → user.id — NOT NULL
- created_date — DATETIME
- del_yn — char(1)
course_register
- id — bigint(20) — Primary key — NOT NULL
- student_id — bigint(20) — Foreign key → user.id
- course_id — bigint(20) — Foreign key → course.id
- completed_state — char(1)
- created_time — datetime
- del_yn — char(1)
exam
- id — bigint(20) — Primary key — NOT NULL
- course_id — bigint(20) — Foreign key → course.id — NOT NULL
- title — varchar(255) — NOT NULL
- content — varchar(3000)
- exam_date — datetime — NOT NULL
- limited_time — datetime
- created_date — datetime
- del_yn — char(1)
exam_outpput
- id — bigint(20) — Primary key — NOT NULL
- exam_id — bigint(20) — Foreign key → exam.id — NOT NULL
- student_id — bigint(20) — Foreign key → user.id — NOT NULL
- content — varchar(3000) — NOT NULL
- score — int(11)
- created_date — datetime
- del_yn — char(1)
lecture
- id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- content — VARCHAR(255)
- course_id — BIGINT — Foreign key → course.id — NOT NULL
- running_time — TIME — NOT NULL
- created_date — DATETIME
- del_yn — char(1)
payment
- id — bigint — Primary key — NOT NULL
- register_id — bigint
- payment_id — bigint
- del_yn — CHAR(1)
payment_method
- id — bigint(20) — Primary key — NOT NULL
- student_id — bigint(20) — Foreign key → user.id — NOT NULL
- card_category — varchar(45)
- card_number — char(16)
- created_date — datetime
- del_yn — char(1)
review
- id — bigint — Primary key — NOT NULL
- course_id — bigint
- student_id — bigint
- content — TEXT
- star — int
- created_date — datetime
- del_yn — CHAR(1)
user
- id — BIGINT — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(255) — NOT NULL
- role — ENUM('학생', '강사', '관리자') — NOT NULL
- created_date — DATETIME
- del_yn — char(1)