erd

Tables (3)

codetable (직원테이블)

  • id (직원아이디) — int — Primary key — NOT NULL
  • c_id (회사고유id) — int — Foreign key → companytable.c_id — NOT NULL
  • r_id (아이디2) — int — Foreign key → ranktable.r_id — NOT NULL
  • name (이름) — varchar
  • tell (전화번호) — varchar
  • memo (메모) — varchar

companytable (회사테이블)

  • c_id (회사고유id) — int — Primary key — NOT NULL
  • c_name (회사이름) — varchar
  • contact (회사연락처) — varchar
  • representative (회사대표) — varchar
  • adress (주소) — varchar

ranktable (직급테이블)

  • r_id (직급아이디) — int — Primary key — NOT NULL
  • name (직급) — varchar