오성푸드

테이블 (37)

ACCOUNT_LIST 계좌정보 리스트 (Untitled2)

  • idx (pk) — int — 기본 키 — NOT NULL
  • bplcCode (pk2) — int — 외래 키 → BUSINESS_PLACE 사업장.bplcCode — NOT NULL
  • bplcNo (pk,fk) — varchar — 외래 키 → BUSINESS_PLACE 사업장.bplcNo — NOT NULL
  • bankCode (Key) — int — 외래 키 → BANK_LIST 은행.bankCode — NOT NULL
  • bankName (Key2) — varchar — 외래 키 → BANK_LIST 은행.bankName — NOT NULL
  • accountNick (Field2) — varchar
  • accountNum (Field3) — varchar
  • depositor (Field4) — varchar

ALARM 알림정보 (Untitled36)

  • userId (Key) — varchar — 기본 키 — NOT NULL
  • alarmDv (Key2) — int — 기본 키 — NOT NULL
  • linkCode (Key3) — int — 기본 키 — NOT NULL
  • bplcNo (pk,fk) — varchar — 외래 키 → BUSINESS_PLACE 사업장.bplcNo — NOT NULL
  • dil (Field) — varchar
  • regDate (Field2) — datetime

BANK_LIST 은행 (Untitled3)

  • bankCode (Key) — int — 기본 키 — NOT NULL
  • bankName (Key2) — varchar — 기본 키 — NOT NULL

BASE_CODE 기초코드 [종합설정] (Untitled12)

  • baseCode (Key) — int — 기본 키 — NOT NULL
  • bplcCode (pk) — int — 외래 키 → BUSINESS_PLACE 사업장.bplcCode — NOT NULL
  • baseNum (Field) — varchar
  • baseName (Field2) — varchar
  • baseDvsnNum (Field3) — varchar
  • baseDvsnName (Field4) — varchar
  • baseYn (Field5) — varchar
  • baseBigo (Field6) — varchar
  • regDate (Field7) — datetime

BOM 레시피정보 (Untitled11)

  • bomCode (Key) — varchar — 기본 키 — NOT NULL
  • prodCode (Key2) — varchar — 외래 키 → PRODUCT 품목정보.prodCode — NOT NULL
  • bplcNo (pk,fk) — varchar — 외래 키 → PRODUCT 품목정보.bplcNo — NOT NULL
  • bomName (Field4) — varchar
  • upperBomCode (Field5) — varchar
  • bomGrade (Field) — varchar
  • regDate (Field6) — datetime

BUSINESS_PLACE 사업장 (Untitled)

  • bplcCode (pk) — int — 기본 키 — NOT NULL
  • bplcNo (pk,fk) — varchar — 기본 키 — NOT NULL
  • bplcName (Field) — varchar
  • bplcCeo (Field2) — varchar
  • bplcSubNo (Field4) — varchar
  • bplcCorpNo (Field5) — varchar
  • bplcItem (Field6) — varchar
  • bplcCnd (Field7) — varchar
  • bplcNckName (Field8) — varchar
  • bplcItemCode (Field9) — varchar
  • bplcCorpDvsn (Field10) — varchar
  • bplcEstDate (Field11) — datetime
  • bplcOpnDate (Field12) — datetime
  • bplcTel (Field13) — varchar
  • bplcAddress (Field14) — varchar
  • bplcFax (Field15) — varchar
  • bplcCeoEmail (Field16) — varchar
  • bplcEtrrptEmail (Field17) — varchar
  • bplcHp (Field18) — varchar
  • bplcAddressDetail (Field19) — varchar
  • regDate (Field20) — datetime

BUY_LIST 구매처 리스트 (Untitled19)

  • idx (Key) — int — 기본 키 — NOT NULL
  • prodCode (Key2) — varchar — 외래 키 → PRODUCT 품목정보.prodCode — NOT NULL
  • supplier (Field) — varchar
  • phoneNumber (Field2) — varchar
  • mobilephoneNumber (Field3) — varchar
  • homepage (Field4) — varchar
  • buyWay (Field5) — varchar
  • modelName (Field6) — varchar
  • partNum (Field7) — varchar

CARD_LIST 카드사 리스트 (Untitled4)

  • idx (Key) — int — 기본 키 — NOT NULL
  • bplcCode (pk) — int — 외래 키 → BUSINESS_PLACE 사업장.bplcCode — NOT NULL
  • bplcNo (pk,fk) — varchar — 외래 키 → BUSINESS_PLACE 사업장.bplcNo — NOT NULL
  • bankCode (Key3) — int — 외래 키 → BANK_LIST 은행.bankCode — NOT NULL
  • bankName (Key23) — varchar — 외래 키 → BANK_LIST 은행.bankName — NOT NULL
  • cardName (Field) — varchar
  • cardNum (Field2) — varchar
  • cardUser (Field3) — varchar

CASH_REC 현금영수증 (Untitled32)

  • cashDate (Field) — date
  • cashUser (Field2) — varchar
  • cashFranchNo (Field3) — varchar
  • cashFranchName (Field4) — varchar
  • cashVat (Field5) — varchar
  • cashServiceDay (Field6) — varchar
  • cashPurchDay (Field7) — varchar
  • cashApprNo (Field8) — varchar
  • cashIssu (Field9) — varchar
  • cashBigo (Field10) — varchar

CC_PAY_LIST 경조사 대장 (Untitled29)

  • ccCode (Key) — varchar — 기본 키 — NOT NULL
  • manCode (Key22) — int — 외래 키 → MAN 사원정보.manCode — NOT NULL
  • ccName (Field) — varchar
  • ccDate (Field2) — varchar
  • ccDetail (Field3) — varchar
  • ccPay (Field4) — varchar
  • ccAcc (Field5) — varchar
  • ccPlace (Field6) — varchar
  • ccMan (Field7) — varchar
  • ccFile (Field8) — varchar

CLAIM_LIST 문제처리 (Untitled28)

  • claimCode (Key) — varchar — 기본 키 — NOT NULL
  • cstmCode (Key2) — int — 외래 키 → CUSTOMER 거래처.cstmCode — NOT NULL
  • cstmName (Field5) — varchar
  • claimDate (Field) — datetime
  • claimTitle (Field2) — varchar
  • claimContent (Field3) — varchar
  • claimReason (Field4) — varchar
  • madeNum (Field6) — varchar
  • country (Field7) — varchar
  • prodSize (Field8) — varchar
  • prodUnitCount (Field9) — varchar
  • prodCount (Field10) — varchar
  • prodUnit (Field11) — varchar
  • claimAction (Field12) — varchar
  • actionDate (Field13) — date
  • claimMeas (Field14) — varchar
  • measDate (Field15) — date

COST_MNG_TMP 원가관리 임시 (Untitled31)

  • costDvsn (Key2) — varchar — 외래 키 → COST_PNAME 원가관리 양식.costDvsn — NOT NULL
  • prodCode (Key3) — varchar — 외래 키 → COST_PNAME 원가관리 양식.prodCode — NOT NULL
  • costCnt (Field) — varchar
  • costEach (Field2) — varchar
  • costDvsn (Field3) — varchar

COST_PNAME 원가관리 양식 (CopyOfUntitled30)

  • costCode (Key) — varchar — 외래 키 → COST_RECORD 원가관리 내역.costCode — NOT NULL
  • costDvsn (Key2) — varchar — 외래 키 → COST_RECORD 원가관리 내역.costDvsn — NOT NULL
  • prodCode (Key3) — varchar — 외래 키 → COST_RECORD 원가관리 내역.prodCode — NOT NULL
  • costDvsn (Field) — varchar

COST_RECORD 원가관리 내역 (Untitled30)

  • costCode (Key) — varchar — 기본 키 — NOT NULL
  • costDvsn (Key2) — varchar — 기본 키 — NOT NULL
  • prodCode (Key3) — varchar — 외래 키 → PRODUCT 품목정보.prodCode — NOT NULL
  • costProd (Field) — varchar
  • costWork (Field2) — varchar
  • costCnt (Field4) — varchar
  • costEach (Field5) — varchar

CUSTOMER 거래처 (Untitled5)

  • cstmCode (Key2) — int — 기본 키 — NOT NULL
  • bplcCode (pk) — int — 외래 키 → BUSINESS_PLACE 사업장.bplcCode — NOT NULL
  • cstmName (Field) — varchar
  • cstmInName (Field2) — varchar
  • cstmCeo (Field3) — varchar
  • cstmCeoEmail (Field4) — varchar
  • cstmNo (Field5) — varchar
  • cstmCnd (Field6) — varchar
  • cstmItem (Field17) — varchar
  • cstmHp (Field7) — varchar
  • cstmFax (Field8) — varchar
  • cstmEmail (Field9) — varchar
  • cstmPlace (Field10) — varchar
  • cstmDvsn (Field11) — varchar
  • cstmAddress (Field12) — varchar
  • cstmEttrptEmail (Field13) — varchar
  • cstmPriceGroup (Field14) — varchar
  • cstmBigo (Field15) — varchar
  • regDate (Field16) — datetime

CUSTOMER_ACCOUNTLIST 거래처별 은행정보 리스트 (Untitled13)

  • cstmCode (Field6) — int — 기본 키
  • bplcCode (pk) — int — 외래 키 → CUSTOMER 거래처.bplcCode — NOT NULL
  • bankCode (Key2) — int — 외래 키 → BANK_LIST 은행.bankCode — NOT NULL
  • bankName (Key22) — varchar — 외래 키 → BANK_LIST 은행.bankName — NOT NULL
  • accountNick (Field2) — varchar
  • accountNum (Field3) — varchar
  • depositor (Field4) — varchar
  • bankCode (Field5) — int
  • idx (Key) — int — NOT NULL

CUSTOMER_BALANCE 거래처별 잔액 (Untitled14)

  • cstmCode (Key2) — int — 외래 키 → CUSTOMER 거래처.cstmCode — NOT NULL
  • cstmBalance (Field) — varchar
  • calDate (Field2) — date

DELIVERY 납품정보 (Untitled33)

  • dlvCode (Key) — varchar — 기본 키 — NOT NULL
  • prodCode (Key2) — varchar — 외래 키 → PRODUCT 품목정보.prodCode — NOT NULL
  • prodName (Key22) — varchar — 외래 키 → PRODUCT 품목정보.prodName — NOT NULL
  • bplcCode (pk) — int — 외래 키 → PRODUCT 품목정보.bplcCode — NOT NULL
  • bplcNo (pk,fk) — varchar — 외래 키 → PRODUCT 품목정보.bplcNo — NOT NULL
  • cstmCode (Key23) — int — 외래 키 → CUSTOMER 거래처.cstmCode — NOT NULL
  • bplcCode (pk2) — int — 외래 키 → CUSTOMER 거래처.bplcCode — NOT NULL

EMPLOYEE_PROJECT 프로젝트 관리 (Untitled22)

  • idx (Key) — int — 기본 키 — NOT NULL
  • bplcNo (pk,fk) — varchar — 외래 키 → BUSINESS_PLACE 사업장.bplcNo — NOT NULL
  • processStatus (Field) — varchar
  • deadLine (Field2) — varchar
  • organization (Field3) — varchar
  • category (Field4) — varchar
  • subCategory (Field5) — varchar
  • beneficiaryCompany (Field6) — varchar
  • supportContent (Field7) — varchar
  • relatedPartners (Field8) — varchar
  • totalAmount (Field9) — varchar
  • subsidy (Field10) — varchar
  • coPayment (Field11) — varchar
  • beneficiaryOfSubsidies (Field12) — varchar
  • effect (Field13) — varchar
  • achievedSales (Field14) — varchar
  • responsiblePerson (Field15) — varchar

ESTIMATE_LIST 견적관리 (Untitled21)

  • estCode (Key) — varchar — 기본 키 — NOT NULL
  • prodCode (Key2) — varchar — 외래 키 → PRODUCT 품목정보.prodCode — NOT NULL
  • cstmCode (Key22) — int — 외래 키 → CUSTOMER 거래처.cstmCode — NOT NULL
  • estName (Field) — varchar
  • prodOrderUnit (Field2) — varchar

GROUP_AUTH 그룹권한 (Untitled27)

  • Key — 기본 키 — NOT NULL
  • bplcNo (pk,fk) — varchar — 외래 키 → BUSINESS_PLACE 사업장.bplcNo — NOT NULL
  • bplcCode (pk) — int — 외래 키 → BUSINESS_PLACE 사업장.bplcCode — NOT NULL
  • groupName (Field) — varchar

INVENTORY 재고목록 (Untitled34)

  • invCode (Key) — varchar — 기본 키 — NOT NULL
  • prodCode (Key2) — varchar — 외래 키 → PRODUCT 품목정보.prodCode — NOT NULL
  • invCount (Field) — varchar
  • invBcount (Field2) — varchar
  • invHcount (Field3) — varchar
  • invBigo (Field4) — varchar

INVENTORY_HIS 재고 히스토리 (Untitled35)

  • invCode (Key) — varchar — 기본 키 — NOT NULL
  • invHisCode (Key2) — varchar — 기본 키 — NOT NULL
  • prodCode (Key3) — varchar — 외래 키 → PRODUCT 품목정보.prodCode — NOT NULL
  • wareBcount (Field) — varchar
  • wareHcount (Field2) — varchar
  • wareDate (Field3) — varchar

MAN 사원정보 (Untitled9)

  • idx (Key) — int — 기본 키 — NOT NULL
  • manCode (Key2) — int — 기본 키 — NOT NULL
  • bplcNo (pk,fk) — varchar — 외래 키 → BUSINESS_PLACE 사업장.bplcNo — NOT NULL
  • manName (Field2) — varchar
  • manCtrtType (Field3) — varchar
  • manCtrtSt (Field4) — varchar
  • manCtrtEnd (Field5) — varchar
  • manAddress (Field6) — varchar
  • manTel (Field7) — varchar
  • passport (Field8) — varchar
  • position (Field9) — varchar
  • manEmail (Field10) — varchar
  • mentDept (Field11) — varchar
  • manClsp (Field12) — varchar
  • manBirth (Field13) — varchar
  • manLocalDvsn (Field14) — varchar
  • manStrtDate (Field15) — datetime
  • manEndDate (Field16) — datetime
  • bankName (Field17) — varchar
  • accountNum (Field18) — varchar

NOTIFYCYCLE 캘린더 (Untitled26)

  • idx (Key) — int — 기본 키 — NOT NULL
  • managementItem (Field) — varchar
  • strtDate (Field2) — varchar
  • cycleUpdate (Field3) — varchar
  • bigo (Field4) — varchar

PRODUCT 품목정보 (Untitled6)

  • prodCode (Key) — varchar — 기본 키 — NOT NULL
  • prodName (Key2) — varchar — 기본 키 — NOT NULL
  • bplcCode (pk) — int — 외래 키 → BUSINESS_PLACE 사업장.bplcCode — NOT NULL
  • bplcNo (pk,fk) — varchar — 외래 키 → BUSINESS_PLACE 사업장.bplcNo — NOT NULL
  • prodModel (Field) — varchar
  • prodPn (Field2) — varchar
  • prodOption (Field3) — varchar
  • prodType (Field4) — varchar
  • prodStandard (Field5) — varchar
  • prodOrderUnit (Field6) — varchar
  • prodInventoryUnit (Field7) — varchar
  • prodQpq (Field8) — varchar
  • prodCount (Field9) — varchar
  • prodSafeInventory (Field10) — varchar
  • prodBigo (Field11) — varchar
  • prodDate (Field12) — varchar
  • bomCode (Field13) — varchar
  • origin (Field14) — varchar
  • unitCount (Field15) — varchar
  • tenDownPrice (Field16) — varchar
  • tenUpPrice (Field17) — varchar
  • consignmentPrice (Field18) — varchar
  • unit (Field19) — varchar
  • regDate (Field20) — datetime

PRODUCT_INVENTORY 품목재고 (Untitled7)

  • bplcNo (Key) — varchar — 기본 키 — NOT NULL
  • bplcCode (Key2) — int — 기본 키 — NOT NULL
  • prodCode (Key3) — varchar — 외래 키 → PRODUCT 품목정보.prodCode — NOT NULL
  • prodName (Key22) — varchar — 외래 키 → PRODUCT 품목정보.prodName — NOT NULL
  • code (Field) — varchar
  • actCode (Field3) — varchar
  • type (Field4) — varchar
  • date (Field5) — datetime
  • total (Field6) — varchar
  • sum (Field7) — varchar
  • regDate (Field8) — datetime
  • cal (Field2) — varchar
  • viewValue (Field9) — varchar

PRODUCT_PRICE 품목단가(시세) (Untitled8)

  • prodCode (Key2) — varchar — 외래 키 → PRODUCT 품목정보.prodCode — NOT NULL
  • date (Field) — datetime
  • price (Field2) — int

RECEIVING_ORDER 수주 (Untitled23)

  • rcoCode (Key) — varchar — 기본 키 — NOT NULL
  • prodCode (Key2) — varchar — 외래 키 → PRODUCT 품목정보.prodCode — NOT NULL
  • rcoScstmCode (Field4) — varchar
  • rcoDcstmCode (Field) — varchar
  • rcoCount (Field2) — varchar
  • rcoTotal (Field3) — varchar

SALARY_HIS 월급계산 (Untitled20)

  • manCode (Key2) — int — 외래 키 → MAN 사원정보.manCode — NOT NULL
  • piPack (Field) — varchar
  • piMan (Field2) — varchar
  • nulGi (Field3) — decimal
  • nulCnt (Field4) — decimal
  • pide (Field5) — decimal
  • pideCnt (Field6) — double
  • ganPi (Field7) — decimal
  • ganCnt (Field8) — decimal
  • lunchBox (Field9) — decimal
  • lunchCnt (Field10) — decimal
  • driCh (Field11) — decimal
  • driChCnt (Field12) — decimal
  • tkgPun (Field13) — decimal
  • tkgPunCnt (Field14) — decimal
  • othe (Field15) — decimal
  • otheCnt (Field16) — decimal
  • driTrim (Field17) — decimal
  • driCnt (Field18) — decimal

SALARY_LOG 급여 정산일지 (Untitled25)

  • manCode (Key2) — int — 외래 키 → MAN 사원정보.manCode — NOT NULL
  • salaryCnt (Field) — varchar
  • salaryDate (Field2) — varchar
  • salaryAdv (Field3) — varchar
  • salaryBigo (Field4) — varchar
  • salaryCtsm (Field5) — varchar
  • salaryBank (Field6) — varchar

SELECT_CUSTOMERLIST 거래처 선택시 사원정보 (Untitled18)

  • idx (Key) — int — 기본 키 — NOT NULL
  • manCode (Key22) — int — 외래 키 → MAN 사원정보.manCode — NOT NULL
  • cstmCode (Key2) — int — 외래 키 → CUSTOMER 거래처.cstmCode — NOT NULL
  • bplcCode (pk) — int — 외래 키 → CUSTOMER 거래처.bplcCode — NOT NULL
  • employeeName (Field) — varchar
  • employeeHp (Field2) — varchar
  • employeePhone (Field3) — varchar
  • employeeEmail (Field4) — varchar

STORAGE 창고 (Untitled10)

  • storCode (Key) — varchar — 기본 키 — NOT NULL
  • bplcNo (pk,fk) — varchar — 외래 키 → BUSINESS_PLACE 사업장.bplcNo — NOT NULL
  • storName (Field) — varchar
  • storOption (Field2) — varchar
  • storBigo (Field3) — varchar

STORAGE_ITEM 창고 물품(재고?) (Untitled24)

  • storCode (Key2) — varchar — 외래 키 → STORAGE 창고.storCode — NOT NULL
  • item (Field) — varchar
  • amount (Field2) — varchar

TAX_BILL 세금계산서 (Untitled15)

  • billCode (Key) — varchar — 기본 키 — NOT NULL
  • cstmCode (Key2) — int — 외래 키 → CUSTOMER 거래처.cstmCode — NOT NULL
  • prodCode (Key3) — varchar — 외래 키 → PRODUCT 품목정보.prodCode — NOT NULL
  • prodName (Key22) — varchar — 외래 키 → PRODUCT 품목정보.prodName — NOT NULL
  • bplcCode (pk) — int — 외래 키 → PRODUCT 품목정보.bplcCode — NOT NULL
  • bplcNo (pk,fk) — varchar — 외래 키 → PRODUCT 품목정보.bplcNo — NOT NULL
  • billDate (Field2) — date
  • sendDate (Field3) — date
  • billUnit (Field4) — varchar
  • appNum (Field5) — varchar
  • prodName (Field6) — varchar
  • gold (Field7) — int
  • cntd (Field8) — int
  • total (Field9) — varchar
  • prepared (Field10) — varchar
  • preparedDate (Field11) — datetime
  • updated (Field12) — varchar
  • updatedDate (Field13) — datetime
  • ceoName (Field14) — varchar
  • ceoEmail (Field15) — varchar
  • cstmEmail (Field16) — varchar
  • billBigo (Field17) — varchar

TO_DO_LIST 일일업무일지 (Untitled16)

  • tdCode (Key) — varchar — 기본 키 — NOT NULL
  • idx (Key3) — int — 외래 키 → MAN 사원정보.idx — NOT NULL
  • bplcNo (pk,fk2) — varchar — 외래 키 → MAN 사원정보.bplcNo — NOT NULL
  • tdTitle (Field) — varchar
  • tdMan (Field7) — varchar
  • tdDetail (Field2) — varchar
  • tdAgency (Field3) — varchar
  • tdDdate (Field4) — varchar
  • tdEdate (Field5) — varchar
  • tdBigo (Field6) — varchar

WARE_LIST 입고 (Untitled17)

  • wareCode (Key) — varchar — 기본 키 — NOT NULL
  • cstmCode (Key2) — int — 외래 키 → CUSTOMER 거래처.cstmCode — NOT NULL
  • prodCode (Key3) — varchar — 외래 키 → PRODUCT 품목정보.prodCode — NOT NULL
  • wareDate (Field) — varchar
  • wareCount (Field4) — varchar
  • wareTotal (Field5) — varchar
  • totalBalance (Field6) — varchar