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