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