company
Tables (3)
Company (employee)
- 사번 (member__complex) — Primary key — NOT NULL
- 사원명 (member_name)
- 부서 (member_table)
- 사원연락처 (member_hp)
- 회사인원 (member_no) — NOT NULL
- 사원이메일 (member_email)
Copy Of Copy Of staff (CopyOfCopyOfcomplex , name)
- 사번 (사원연락처) — varchar(15) — Foreign key → staff.사번
- b6554 (011-7777-5558) — text
- a5748 (017-1425-5414) — text
- c2345 (018-477-0000) — text
- d6662 (010-5959-4444) — text
- a78522 (019-95231-122) — text
- b1234 (016-456-7895) — text
- c7500 (010-8522-4561) — text
- d7511 (012-7321-4652) — text
- c4444 (013-5202-4874) — text
- e8888 (014-574-1554) — text
- e7721 (010-4444-6666) — text
- e6632 (011+-5556-4789) — text
- a9887 (010-999-9595) — text — NOT NULL
- c3333 (010-5959-8282) — text
staff (complex , name)
- 사번 (성함) — Foreign key → Company.사번
- a9887 (공길동) — NOT NULL
- b6554 (낭길동)
- a5748 (당길동)
- c2345 (랑길동)
- d6662 (망길동)
- a78522 (방길동)
- b1234 (상길동)
- c7500 (앙길동)
- d7511 (장길동)
- c4444 (창길동)
- e8888 (캉길동)
- e7721 (탕길동)
- e6632 (팡길동)
- c3333 (홍길동)