AdventureWorks

테이블 (9)

근무교대 (HumanResources.Shift)

  • 근무교대ID (ShiftID) — tinyint — 기본 키 — NOT NULL
  • Name — dbo.Name — NOT NULL
  • StartTime — time(7) — NOT NULL
  • EndTime — time(7) — NOT NULL
  • ModifiedDate — datetime — NOT NULL

부서 (HumanResources.Department)

  • 부서ID (DepartmentID) — smallint — 기본 키 — NOT NULL
  • 부서명 (Name) — dbo.Name — NOT NULL
  • GroupName — dbo.Name — NOT NULL
  • ModifiedDate — datetime — NOT NULL

사람 (Person.Person)

  • 업무엔티티ID (BusinessEntityID) — int — 외래 키 → 업무엔티티.업무엔티티ID — NOT NULL
  • PersonType — nchar(2) — NOT NULL — SC = Store Contact IN = Individual (retail) customer SP = Sales person EM = Employee (non-sales) VC = Vendor contact GC…
  • NameStyle — bit — NOT NULL — 0 : West style (First : name Last :Family) 1 : East style
  • Title — nvarchar(8) — Mr. Ms. etc..
  • FirstName — dbo.Name — NOT NULL
  • MiddleName — dbo.Name
  • LastName — dbo.Name — NOT NULL
  • Suffix — nvarchar(10) — Surname suffix. For example, Sr. or Jr.
  • EmailPromotion — int — NOT NULL — 0 = Eamil Promotion No 1 = e-mail promotions Yes 2 = Email Promotion Y AdventureWorks and 선택된 파트너들 Default: 0
  • AdditionalContactInfo — xml
  • Demographics — xml
  • rowguid — uniqueidentifier — NOT NULL
  • ModifiedDate — datetime — NOT NULL

사원 (HumanResources.Employee)

  • 업무엔티티ID (BusinessEntityID) — int — 외래 키 → 사람.업무엔티티ID — NOT NULL
  • NationalIDNumber — nvarchar(15) — NOT NULL — 주민번호, 사회보장번호 같은 국가별 고유 인식코드
  • LoginID — nvarchar(256) — NOT NULL
  • OrganizationNode — hierarchyid — 계층별조직코드
  • OrganizationLevel — AS
  • 직업 명 (JobTitle) — nvarchar(50) — NOT NULL
  • BirthDate — date — NOT NULL
  • 결혼 상태 (MaritalStatus) — nchar(1) — NOT NULL
  • Gender — nchar(1) — NOT NULL
  • HireDate — date — NOT NULL
  • 고용형태 (SalariedFlag) — bit — NOT NULL — 0 = 시간제 1 = 전일제 Default: 1
  • 휴가가능시간수 (VacationHours) — smallint — NOT NULL
  • 병가가능시간수 (SickLeaveHours) — smallint — NOT NULL
  • 현재직원여부 플래그 (CurrentFlag) — bit — NOT NULL — 0 = 현재근무아님 1 = 근무중 Default: 1
  • rowguid — uniqueidentifier — NOT NULL
  • ModifiedDate — datetime — NOT NULL

사원부서이력 (HumanResources.EmployeeDepartmentHistory)

  • 시작일 (StartDate) — date — 기본 키 — NOT NULL
  • 업무엔티티ID (BusinessEntityID) — int — 외래 키 → 사원.업무엔티티ID — NOT NULL
  • 부서ID (DepartmentID) — smallint — 외래 키 → 부서.부서ID — NOT NULL
  • 근무교대ID (ShiftID) — tinyint — 외래 키 → 근무교대.근무교대ID — NOT NULL
  • EndDate — date
  • ModifiedDate — datetime — NOT NULL

사원월급이력 (HumanResources.EmployeePayHistory)

  • RateChangeDate — datetime — 기본 키 — NOT NULL
  • 업무엔티티ID (BusinessEntityID) — int — 외래 키 → 사원.업무엔티티ID — NOT NULL
  • Rate — money — NOT NULL
  • PayFrequency — tinyint — NOT NULL
  • ModifiedDate — datetime — NOT NULL

업무엔티티 (Person.BusinessEntity)

  • 업무엔티티ID (BusinessEntityID) — int — 기본 키 — NOT NULL
  • rowguid — uniqueidentifier — NOT NULL
  • ModifiedDate — datetime — NOT NULL

이력서 (HumanResources.JobCandidate)

  • 이력서ID (JobCandidateID) — int — 기본 키 — NOT NULL
  • 업무엔티티ID (BusinessEntityID) — int — 외래 키 → 사원.업무엔티티ID — NOT NULL
  • Resume — xml
  • ModifiedDate — datetime — NOT NULL

이메일주소 (Person.EmailAddress)

  • 이메일주소순번 (EmailAddressID) — int — 기본 키 — NOT NULL
  • 업무엔티티ID (BusinessEntityID) — int — 외래 키 → 사람.업무엔티티ID — NOT NULL
  • EmailAddress — nvarchar(50)
  • rowguid — uniqueidentifier — NOT NULL
  • ModifiedDate — datetime — NOT NULL