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 (홍길동)