education
Tables (3)
course (강의)
- id (primary key auto_increment) — bigint — Primary key
- category (-) — enum('WEB','APP','GAME','ALGORITHM','INFRA','DATABASE')
- name (unique not null) — varchar(100) — NOT NULL
- instructor_id (not null, foreign key) — bigint — Foreign key → member.id — NOT NULL
- cost (not null) — int — NOT NULL
- description (-.) — text
- created_at (not null default current timestamp) — timestamp — NOT NULL
- updated_at (on update current timestamp default current timestamp) — timestamp
- deleted (default false) — boolean
- opened (default false.) — boolean
member (회원)
- id (id (pk)) — bigint — Primary key
- email (unique not null) — varchar(255) — NOT NULL
- nickname (not null) — varchar(200) — NOT NULL
- created_at (not null default current timestamp) — timestamp — NOT NULL
- updated_at (on update current timestamp default current timestamp) — timestamp
- deleted (default false) — boolean
member_course (회원 수강 강의)
- id (id (pk)) — bigint — Primary key
- member_id (member_id (fk)) — bigint — Foreign key → member.id — NOT NULL
- course_id (course_id (fk)) — bigint — Foreign key → course.id — NOT NULL
- created_at (not null default current timestamp) — timestamp — NOT NULL
- updated_at (on update current timestamp default current timestamp) — timestamp
- deleted (default false) — boolean