d
Tables (11)
feeds
- feed_id — BINARY(16) — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- type — VARCHAR(255) — NOT NULL
- content — JSON — NOT NULL
- estimated_time — INT
- thumbnail_url — VARCHAR(255)
- answer_and_commentary — JSON
group_members
- group_id — BINARY(16) — Primary key — NOT NULL
- member_id — BINARY(16) — Primary key — NOT NULL
groups
- group_id — BINARY(16) — Primary key — NOT NULL
- 이름 — VARCHAR(100) — NOT NULL
- 설명 — TEXT
issued_learning_content
- issued_learning_content_id — BINARY(16) — Primary key — NOT NULL
- group_id — BINARY(16)
- 학습_내용_id — BINARY(16) — NOT NULL
- 시작_시간 — DATETIME
- 마감_시간 — DATETIME
- 진행_현황 — TINYINT — NOT NULL
issued_learning_content_details
- issued_learning_content_id — BINARY(16) — Primary key — NOT NULL
- member_id — BINARY(16) — Primary key — NOT NULL
- progress_percent — TINYINT — NOT NULL
learned_feeds
- learned_feed_id — BINARY(16) — Primary key — NOT NULL
- member_id — BINARY(16) — NOT NULL
- learning_content_feed_id — BINARY(16) — NOT NULL
learning_content_feeds
- learning_content_feed_id — BINARY(16) — Primary key — NOT NULL
- learning_content_id — BINARY(16) — NOT NULL
- feed_id — BINARY(16) — NOT NULL
learning_contents
- learning_content_id — BINARY(16) — Primary key — NOT NULL
- 제목 — VARCHAR(255) — NOT NULL
- 설명 — TEXT
- 썸네일_url — VARCHAR(255)
members
- member_id — BINARY(16) — Primary key — NOT NULL
- 이메일 — VARCHAR(255) — NOT NULL
- 이름 — VARCHAR(10)
- 타입 — VARCHAR(20) — NOT NULL
- 성별 — CHAR(1)
- 전화번호 — VARCHAR(20)
- 비밀번호 — VARCHAR(255) — NOT NULL
student_infos
- member_id — BINARY(16) — Primary key — NOT NULL
- 수준 — VARCHAR(10) — NOT NULL
- 학년 — VARCHAR(10) — NOT NULL
- 메모 — TEXT
teacher_infos
- member_id — BINARY(16) — Primary key — NOT NULL
- 담당_과목 — VARCHAR(20) — NOT NULL
- 경력_년수 — INT
- 메모 — TEXT