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)