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
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