dorolms

Tables (7)

announcement (공지)

  • announcement_id (공지 id) — INT — Primary key — NOT NULL
  • author_id (사용자 id) — INT — Foreign key → user.user_id — NOT NULL
  • title (제목) — VARCHAR2(255)
  • content (내용) — TEXT
  • created_at (생성 일시) — TIMESTAMP

application (강의 신청)

  • application_id (Key) — INT — Primary key — NOT NULL
  • lecture_id (Key2) — INT — Foreign key → lecture.lecture_id — NOT NULL
  • user_id (강사 id) — INT — Foreign key → user.user_id — NOT NULL
  • applied_role (Field) — ENUM
  • assignment_status (Field2) — ENUM
  • created_at (Field3) — TIMESTAMP

lecture (강의)

  • lecture_id (Key) — INT — Primary key — NOT NULL
  • user_id (사용자 id) — INT — Foreign key → user.user_id — NOT NULL
  • title (Field) — VARCHAR2(255)
  • type (유형) — ENUM
  • category (구분) — VARCHAR2(100)
  • status (강의 상태) — ENUM
  • location (Field2) — VARCHAR2(255)
  • target (대상) — VARCHAR2(255)
  • capacity (인원) — VARCHAR2(100)
  • content (콘텐츠) — TEXT
  • end_date (신청 마감기한) — DATE
  • fee (강의료) — TEXT
  • recruitment_main (Field3) — INT
  • recruitment_assist (Field4) — INT
  • note (특이사항) — TEXT
  • attachment_url (첨부 파일) — VARCHAR2(255)
  • created_at (생성 일시) — TIMESTAMP

lecture_schedule (강의 시간)

  • schedule_id (Key) — INT — Primary key — NOT NULL
  • lecture_id (강의 id) — INT — Foreign key → lecture.lecture_id — NOT NULL
  • date (Field) — DATE
  • start_time (Field2) — TIME
  • end_time (Field3) — TIME

message (Untitled8)

    notification (알림)

      user (사용자)

      • user_id (사용자 id) — INT — Primary key — NOT NULL
      • role (강사/매니저) — ENUM — NOT NULL
      • name (이름) — VARCHAR2(100) — NOT NULL
      • email (이메일) — VARCHAR2(255) — NOT NULL
      • password (비밀번호) — VARCHAR2(255) — NOT NULL
      • profile_photo (프로필 사진) — VARCHAR2(255)
      • phone_num (전화번호) — TEXT
      • major (전공) — TEXT — NOT NULL
      • portfolio (포트폴리오) — TEXT
      • created_at (생성 일시) — TIMESTAMP — NOT NULL