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