study

Tables (3)

employee

  • id — int — Primary key — NOT NULL
  • name — varchar(45) — NOT NULL
  • email — varchar(100) — NOT NULL
  • salary — int — NOT NULL
  • team — varchar(20) — NOT NULL
  • quit_data — date
  • created_at — datetime
  • role_id — int — Foreign key → role.id — NOT NULL — 직책 아이디

employee_info

  • id — int — Foreign key → employee.id — NOT NULL
  • adress — varchar(100)
  • etc — text

role

  • id — int — Primary key — NOT NULL — 직책 아이디
  • name — varchar(10) — NOT NULL — 직책 이름
  • min_salary — int — NOT NULL — 최저 연봉