pool

Tables (3)

employ

  • 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_date — date
  • created_at — datetime
  • role_id — int — Foreign key → role_name.id — NOT NULL — 직책아이디

employ_info

  • id (id2) — int — Foreign key → employ.id — NOT NULL
  • address — varchar(100) — NOT NULL
  • etc — text

role_name

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