lms
Tables (6)
category
- id — INT
- name — VARCHAR(255) — NOT NULL
- parent_id — INT — Foreign key → category.id
content
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- vid_playtime — INT
- vid_path — VARCHAR(255)
- attachment_path — VARCHAR(255)
- body_path — VARCHAR(255)
- section_id — INT — Foreign key → section.id — NOT NULL
course
- id — INT
- title — VARCHAR(255) — NOT NULL
- category_id — INT — Foreign key → category.id — NOT NULL
- summary — TEXT
- detail_path — VARCHAR(255)
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
notice
- id — BIGINT
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- course_id — INT — Foreign key → course.id — NOT NULL
- body_path — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
section
- id — INT
- name — VARCHAR(255) — NOT NULL
- seq — INT — NOT NULL
user
- id — BIGINT
- name — VARCHAR(255) — NOT NULL