nextstep_lms
Tables (8)
answer
- id — bigint
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- contents — clob
- deleted — boolean — NOT NULL
- question_id — bigint
- writer_id — bigint
course
- id — bigint
- title — varchar(255) — NOT NULL
- creator_id — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
delete_history
- id — bigint — Primary key — NOT NULL
- content_id — bigint
- content_type — varchar(255)
- created_date — timestamp
- deleted_by_id — bigint
ns_user
- id — bigint
- user_id — varchar(20) — NOT NULL
- password — varchar(20) — NOT NULL
- name — varchar(20) — NOT NULL
- email — varchar(50)
- created_at — timestamp — NOT NULL
- updated_at — timestamp
question
- id — bigint
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- contents — clob
- deleted — boolean — NOT NULL
- title — varchar(100) — NOT NULL
- writer_id — bigint
session
- id — bigint
- course_id — bigint — NOT NULL
- image_id — bigint — NOT NULL
- start_date — timestamp — NOT NULL
- end_date — timestamp — NOT NULL
- pricing_type — char(1) — NOT NULL
- session_status — char(1) — NOT NULL
- available_seat — int — NOT NULL
- creator_id — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
session_image
- id — bigint
- session_id — bigint — NOT NULL
- file_path — varchar(500) — NOT NULL
- creator_id — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
session_users
- id — bigint
- session_id — bigint — NOT NULL
- ns_user_id — bigint — NOT NULL
- creator_id — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp