softsync
Tables (17)
categories (카테고리)
- id (카테고리id) — BIGINT — Primary key
- name — VARCHAR(255) — NOT NULL
- id (id2) — BIGINT — Foreign key → categories.id
companies (협력회사)
- brn (협력회사id) — VARCHAR(20) — Primary key
- company_name — VARCHAR(50) — NOT NULL
- company_address — VARCHAR(300) — NOT NULL
- company_ceo — VARCHAR(20) — NOT NULL
- manager — VARCHAR(20) — NOT NULL
- manager_email — VARCHAR(50) — NOT NULL
- manager_tel — VARCHAR(20) — NOT NULL
- company_account — VARCHAR(30) — NOT NULL
- company_note — VARCHAR(300)
contracts (계약)
- contract_number (계약id) — INT — Primary key
- contract_date — DATE
- contract_path — VARCHAR(100)
- lead_time — INT
- unit_price — INT
- contractYn — CHAR(1)
- contract_note — VARCHAR(255)
- id (품목id) — BIGINT — Foreign key → items.id
- brn (협력회사id) — VARCHAR(20) — Foreign key → companies.brn
- id (직원id) — VARCHAR(255) — Foreign key → softsync_employee.id
inspections (진척검수)
- inspecNo (검수id) — BIGINT — Primary key
- inspecPlan — DATE — NOT NULL
- quantity — INT — NOT NULL
- times — INT — NOT NULL
- inspecYn — CHAR(1) — NOT NULL
- percent — VARCHAR(255)
- inspecDate — DATE
- inspecNote — VARCHAR(255)
- orderNo (발주id) — VARCHAR(255) — Foreign key → orders.orderNo
inventories (재고)
- id (인벤토리id) — BIGINT — Primary key
- quantity — INT
- initialQuantity — INT
inventory_periods
- id (인피id) — BIGINT — Primary key
- date — DATE — NOT NULL
- id (인벤토리id) — BIGINT — Foreign key → inventories.id
- id (출고리스트id) — BIGINT — Foreign key → shipment_lists.id
- num (입고리스트id) — INT — Foreign key → receive_lists.num
invoices (거래명세서)
- num (명세서id) — INT — Primary key
- publishDate — DATE
- publishYn — CHAR(1)
- receiveNumber — INT — Foreign key → receivings.receiveNumber
items (품목)
- id (품목id) — BIGINT — Primary key
- itemCode — VARCHAR(255)
- itemName — VARCHAR(255)
- dimensions — VARCHAR(255)
- material — VARCHAR(255)
- blueprintPath — VARCHAR(255)
- id (카테고리id) — BIGINT — Foreign key → categories.id
- id (생산계획id) — BIGINT — Foreign key → production_plans.id
notices
- boardNo (공지id) — INT — Primary key
- employeeId — INT
- title — VARCHAR(255)
- content — TEXT
- regDate — DATETIME — NOT NULL
- modDate — DATETIME
- id (직원id) — VARCHAR(255) — Foreign key → softsync_employee.id
orders (발주)
- orderNo (발주id) — VARCHAR(255) — Primary key
- inspectionTime — VARCHAR(255) — NOT NULL
- inspectYNG — CHAR(1) — NOT NULL
- orderQuantity — INT — NOT NULL
- orderDate — DATE — NOT NULL
- receiveDuedate — DATE — NOT NULL
- orderYn — CHAR(1) — NOT NULL
- receiptYn — CHAR(1) — NOT NULL
- orderNote — TEXT
- totalPrice — VARCHAR(255)
- contract_number (계약id) — INT — Foreign key → contracts.contract_number
procurement_plans (조달계획)
- id (조달계획id) — BIGINT — Primary key
- procurementInterval — INT — NOT NULL
- procurementQuantity — INT — NOT NULL
- procurementDueDate — DATE — NOT NULL
- id (생산계획id) — BIGINT — Foreign key → production_plans.id
production_plans (생산계획(외부))
- id (생산계획id) — BIGINT — Primary key
- productionStartDate — DATE — NOT NULL
- productionEndDate — DATE — NOT NULL
- productCode — VARCHAR(255) — NOT NULL
- productName — VARCHAR(255) — NOT NULL
- productionQuantity — INT — NOT NULL
- itemQuantity — INT — NOT NULL
receive_lists (입고내역)
- num (입고리스트id) — INT — Primary key
- quantity — INT — NOT NULL
- sysdate — DATE — NOT NULL
- receiveNumber — INT — Foreign key → receivings.receiveNumber
receivings (입고)
- receiveNumber — INT — Primary key
- receiveDate — DATE
- receiveQuantity — INT — NOT NULL
- receiveClosingYn — CHAR(1) — NOT NULL
- inspectYn — CHAR(1) — NOT NULL
- orderNo (발주id) — VARCHAR(255) — Foreign key → orders.orderNo
- id (인벤토리id) — BIGINT — Foreign key → inventories.id
shipment_lists (출고내역)
- id (출고리스트id) — BIGINT — Primary key
- quantity — INT — NOT NULL
- inventoryQuantity — INT — NOT NULL
- shipmentDate — DATE — NOT NULL
- id (출고id) — BIGINT — Foreign key → shipments.id
shipments (출고)
- id (출고id) — BIGINT — Primary key
- shipmentDate — DATE — NOT NULL
- id (조달계획id) — BIGINT — Foreign key → procurement_plans.id
- id (인벤토리id) — BIGINT — Foreign key → inventories.id
softsync_employee
- id (직원id) — VARCHAR(255) — Primary key
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- gender — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone — VARCHAR(255) — NOT NULL
- EMP_num — INT — NOT NULL
- department — VARCHAR(255) — NOT NULL
- u_registerDate — DATETIME — NOT NULL