learn-hub
Tables (6)
Board (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- member_id (Field) — BIGINT
- title (Field2) — VARCHAR
- content (Field3) — TEXT
- type (Field6) — VARCHAR
- create_date (Field4) — TIMESTAMP
- update_date (Field5) — TIMESTAMP
Lecture (Untitled6)
- id (식별자) — BIGINT — Primary key — NOT NULL
- file_id (썸네일) — BIGINT
- board_id (Field)
- category (Field2)
- price (가격) — NUMBER
- create_date (생성일) — TIMESTAMP
- update_date (수정일) — TIMESTAMP
LectureChapter
- id (Key) — BIGINT — Primary key — NOT NULL
- lecture_id (Field) — BIGINT
- title (Field2) — VARCHAR
LectureVideo (Untitled3)
- id (식별자) — BIGINT — Primary key — NOT NULL
- lecture_chapter_id (Field) — BIGINT
- file_id (Field2) — BIGINT
- title (제목) — VARCHAR
- length (길이) — VARCHAR
Member (Untitled)
- id (식별자) — BIGINT — Primary key — NOT NULL
- login_id (아이디) — VARCHAR
- password (비밀번호) — VARCHAR
- name (이름) — VARCHAR
- phone (전화) — VARCHAR
- status (상태) — VARCHAR
- role (권한) — VARCHAR
- create_date (생성일) — TIMESTAMP
- update_date (수정일) — TIMESTAMP
file (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- original_name (Field) — VARCHAR
- save_name (Field2) — VARCHAR
- size (Field5)
- create_date (Field3) — TIMESTAMP
- update_date (Field4) — TIMESTAMP