오성푸드
테이블 (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