MJ

Tables (31)

Auth (권한)

  • AuthCode (권한코드) — int — Primary key — NOT NULL
  • AutnName (권한명) — nvarchar(20)

BadType (불량유형)

  • BadTypeCode (불량유형코드) — char(5) — Primary key — NOT NULL
  • BadTypeName (불량유형명) — nvarchar(50)
  • ProcessCode (공정코드) — char(3) — Foreign key → Process.ProcessCode — NOT NULL

Customer (거래처정보)

  • CustomerCode (거래처코드) — char(10) — Primary key — NOT NULL
  • CustomerName (거래처명) — nvarchar(20)
  • CustomerAddress (거래처주소) — nvarchar(100)
  • TelNumber (전화번호) — varchar(20)
  • FaxNumber (팩스번호) — varchar(20)
  • ContactName (담당자이름) — nvarchar(20)
  • ContactGrade (담당자직책) — nvarchar(20)
  • ContactTelNum (담당자연락처) — nvarchar(20)
  • ContactEmail (담당자이메일) — nvarchar(100)
  • CusCategoryCode (거래처분류코드) — int — Foreign key → CustomerCategory.CusCategoryCode — NOT NULL

CustomerCategory (거래처 분류)

  • CusCategoryCode (거래처분류코드) — int — Primary key — NOT NULL
  • CusCategryName (거래처분류명) — nvarchar(20)

Department (부서)

  • DepartmentCode (부서코드) — int — Primary key — NOT NULL
  • DepartmentName (부서명) — nvarhcar(20)

Employee (직원)

  • EmployeeNo (사번) — varchar(10) — Primary key — NOT NULL
  • Password (비밀번호) — char(6)
  • Name (이름) — nvarchar(20)
  • DateJoined (입사일자) — Date
  • ForRetirement (퇴사여부) — bit
  • Email (메일주소) — varchar(100 — NOT NULL
  • DateRetired (퇴사일자) — Date — NOT NULL
  • PhoneNumber (연락처) — varchar(20) — NOT NULL
  • AuthCode (권한코드) — int — Foreign key → Auth.AuthCode — NOT NULL
  • GradeCode (직급코드) — int — Foreign key → Grade.GradeCode — NOT NULL
  • DepartmentCode (부서코드) — int — Foreign key → Department.DepartmentCode — NOT NULL

Facilities (설비)

  • facilitiesCode (설비코드) — char(5) — Primary key — NOT NULL
  • FacilitiesName (설비명) — nvarchar(20)
  • Datemanufacture (제조일자) — date
  • Manufacturer (제조사) — nvarchar(50)
  • PerchaseDate (구매일자) — date
  • ProcessCode (공정코드) — char(3) — Foreign key → Process.ProcessCode — NOT NULL

Function (기능)

  • FunctionCode (기능코드) — varchar(20) — Primary key — NOT NULL
  • FunctionName (기능명) — nvarchar(20)
  • FCCode (기능분류코드) — varchar(20) — Foreign key → FunctionCategory.FCCode — NOT NULL

FunctionCategory (기능분류)

  • FCCode (기능분류코드) — varchar(20) — Primary key — NOT NULL
  • FCName (기능분류명) — nvarchar(20)

Grade (직급)

  • GradeCode (직급코드) — int — Primary key — NOT NULL
  • GradeName (직급명) — nvarchar(20)

Item (품목정보)

  • ItemCode (품목코드) — varchar(8) — Primary key — NOT NULL
  • ItemName (품목명) — nvarchar(20)
  • Standard (규격) — varchar(20)
  • UnitCode (단위코드) — int — Foreign key → Unit.UnitCode — NOT NULL
  • CustomerCode (거래처코드) — char(10) — Foreign key → Customer.CustomerCode — NOT NULL
  • ItemLCategoryCode (품목대분류코드) — char(2) — Foreign key → ItemLCategory.ItemLCategoryCode — NOT NULL
  • ItemMCategoryCode (품목중분류코드) — char(3) — Foreign key → ItemMiddleCategory.ItemMCategoryCode — NOT NULL

ItemLCategory (품목대분류)

  • ItemLCategoryCode (품목대분류코드) — char(2) — Primary key — NOT NULL
  • ItemLCategoryName (품목대분류명) — nvarchar(20)

ItemMiddleCategory (품목중분류)

  • ItemMCategoryCode (품목중분류코드) — char(3) — Primary key — NOT NULL
  • ItemMCategoryName (품목중분류명) — nvarchar(20)
  • ItemLCategoryCode (품목대분류코드) — char(3) — Foreign key → ItemLCategory.ItemLCategoryCode — NOT NULL

LoginRecords (로그인기록)

  • ID (식별자) — int — Primary key — NOT NULL
  • EmployeeNo (사번) — varchar(10) — Foreign key → Employee.EmployeeNo — NOT NULL
  • DateLogined (로그인일자) — DateTime

Mold (금형정보)

  • MoldNo (금형번호) — nchar(20) — Primary key — NOT NULL
  • MoldNmae (금형이름) — nvarchar(50)
  • DateMaked (제조일자) — Date
  • GuaranteeCount (보증타발수) — int
  • NowCount (현타발수) — int
  • CustomerCode (거래처코드) — char(10) — Foreign key → Customer.CustomerCode — NOT NULL
  • ForDisposal (폐기여부) — bit
  • DataDisposal (폐기일자) — date
  • RackNo (랙번호) — int — Foreign key → MoldRack.RackNo — NOT NULL
  • Key — Foreign key → MoldRack.MoldStorageCode — NOT NULL

MoldRack (금형랙정보)

  • RackNo (랙번호) — int — Primary key — NOT NULL
  • MoldStorageCode (창고코드) — char(1) — Primary key — NOT NULL

Packing (제품포장정보)

  • PackingLot (포장LOT) — varchar(20) — Primary key — NOT NULL
  • ItemCode (품목코드) — varchar(8) — Foreign key → Item.ItemCode — NOT NULL
  • PackingAmount (포장수량) — decimal
  • PackingDate (포장일자) — date
  • Field

PackingDetail (포장상세정보)

  • PackingLot (포장LOT) — varchar(20) — Foreign key → Packing.PackingLot — NOT NULL
  • OrderNo (작업지시번호) — varchar(20) — Foreign key → PressWorkResult.OrderNo — NOT NULL
  • LotNO (로트넘버) — varchar(20) — Foreign key → StorageWarehousing.LotNO — NOT NULL
  • HeatDate (열처리일자) — date
  • HeatEmployeeCode (열처리직원코드) — varchar(10)
  • Field

PressBadDetail (프레스 불량 내역)

  • OrderNo (작업지시번호) — varchar(20) — Foreign key → PressWorkOrder.OrderNo — NOT NULL
  • BadTypeCode (불량유형코드) — char(5) — Foreign key → BadType.BadTypeCode — NOT NULL
  • BadAmount (불량수량) — decimal

PressWorkOrder (프레스 작업지시)

  • OrderNo (작업지시번호) — varchar(20) — Primary key — NOT NULL
  • OrderDate (작업일자) — date
  • ItemCode (품목코드) — varchar(8) — Foreign key → Item.ItemCode — NOT NULL
  • WorkCategoryCode (작업구분코드) — char(2) — Foreign key → WorkCategory.WorkCategoryCode — NOT NULL
  • EmployeeNo (사번) — varchar(10) — Foreign key → Employee.EmployeeNo — NOT NULL

PressWorkResult (프레스생산결과)

  • OrderNo (작업지시번호) — varchar(20) — Foreign key → PressWorkOrder.OrderNo — NOT NULL
  • TotalOutputAmout (총완료중량) — decimal
  • TotalBadAmount (총불량중량) — decimal
  • PCS (타발수량) — int
  • TotalInputAmount (총투입량) — decimal

PressWorkUseLot (프레스생산사용LOT)

  • OrderNo (작업지시번호) — varchar(20) — Foreign key → PressWorkOrder.OrderNo — NOT NULL
  • LotNO (로트넘버) — varchar(20) — Foreign key → StorageWarehousing.LotNO — NOT NULL

Process (공정정보)

  • ProcessCode (공정코드) — char(3) — Primary key — NOT NULL
  • ProcessName (공정명) — nvarchar(20)

SetFunctionAuth (권한별기능설정)

  • AuthCode (권한코드) — int — Foreign key → Auth.AuthCode — NOT NULL
  • FunctionCode (기능코드) — varchar(20) — Foreign key → Function.FunctionCode — NOT NULL
  • Searchable (검색가능여부) — bit
  • Updatable (수정가능여부) — bit
  • Deletable (삭제가능여부) — bit
  • Insertable (등록가능여부) — bit

SlittingWorkDetail (슬리팅작업상세내역)

  • SlittingLot (작업Lot번호) — varchar(20) — Primary key — NOT NULL
  • OrderNo (작업지시번호) — varchar(20) — Foreign key → SlittingWorkOrder.OrderNo — NOT NULL
  • ItemCode (품목코드) — varchar(8) — Foreign key → Item.ItemCode — NOT NULL
  • LotAmount (로트중량) — decimal

SlittingWorkOrder (슬리팅 작업지시)

  • OrderNo (작업지시번호) — varchar(20) — Primary key — NOT NULL
  • OrderDate (작업일자) — date
  • LotNO (로트넘버) — varchar(20) — Foreign key → StorageWarehousing.LotNO — NOT NULL
  • LossAmount (로스중량) — decimal
  • EmployeeNo (사번) — varchar(10) — Foreign key → Employee.EmployeeNo — NOT NULL
  • WorkCategoryCode (작업구분코드) — char(2) — Foreign key → WorkCategory.WorkCategoryCode — NOT NULL

Storage (창고정보)

  • StorageCode (창고코드) — char(5) — Primary key — NOT NULL
  • StorageName (창고명) — nvarchar(20)

StorageRelease (출고내역)

  • ReleasNo (출고번호) — int — Primary key — NOT NULL
  • DateRelease (출고일자) — date
  • ReleasQTY (출고량) — decimal
  • LotNO (로트넘버) — varchar(20) — Foreign key → StorageWarehousing.LotNO — NOT NULL

StorageWarehousing (입고내역)

  • LotNO (로트넘버) — varchar(20) — Primary key — NOT NULL
  • DateWarehousing (입고일자) — date
  • WarehousingQTY (입고수량) — decimal
  • ItemCode (품목코드) — varchar(8) — Foreign key → Item.ItemCode — NOT NULL
  • StorageCode (창고코드) — char(5) — Foreign key → Storage.StorageCode — NOT NULL
  • RelaseStatus (출고여부) — bit

Unit (단위)

  • UnitCode (단위코드) — int — Primary key — NOT NULL
  • UnitName (단위명칭) — varchar(10)

WorkCategory (작업구분)

  • WorkCategoryCode (작업구분코드) — char(2) — Primary key — NOT NULL
  • WorkCategoryName (작업구분명) — nvarchar(10)