ㅁㄴㅇㄹ
Tables (6)
account
- idx — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- pw — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
lecture
- idx — BIGINT — Primary key — NOT NULL
- owner_idx — BIGINT — Foreign key → account.idx — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- youtube_pl_url — VARCHAR(500) — NOT NULL
- youtube_pl_id — VARCHAR(100) — NOT NULL
- video_count — INT — NOT NULL
- last_synced_at — DATETIME
- youtube_pl_etag — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- deleted_at — DATETIME
lecture_progress
- idx — BIGINT — Primary key — NOT NULL
- account_idx — BIGINT — Foreign key → account.idx — NOT NULL
- lecture_idx — BIGINT — Foreign key → lecture.idx — NOT NULL
- video_idx — BIGINT — Foreign key → video.idx — NOT NULL
- last_position_s — INT — NOT NULL
- updated_at — DATETIME — NOT NULL
study_group
- idx — BIGINT — Primary key — NOT NULL
- owner_idx — BIGINT — Foreign key → account.idx — NOT NULL
- name — VARCHAR(200) — NOT NULL
- description — TEXT
- is_public — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME
study_group_member
- idx — BIGINT — Primary key — NOT NULL
- group_idx — BIGINT — Foreign key → study_group.idx — NOT NULL
- member_idx — BIGINT — Foreign key → account.idx — NOT NULL
- created_at — DATETIME — NOT NULL
video
- idx — BIGINT — Primary key — NOT NULL
- lecture_idx — BIGINT — Foreign key → lecture.idx — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- youtube_id — VARCHAR(100) — NOT NULL
- youtube_url — VARCHAR(500) — NOT NULL
- thumbnail_url — VARCHAR(500)
- duration_sec — INT
- position — INT — NOT NULL
- youtube_item_id — VARCHAR(100)
- channel_title — VARCHAR(200)
- published_at — DATETIME
- is_available — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL