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