hexagon
Tables (14)
Client (거래처)
- id — number — Primary key — NOT NULL
- trade_name — varchar2 — NOT NULL
- ceo_name — varchar2 — NOT NULL
- business_type — varchar2 — NOT NULL
- business_event — varchar2 — NOT NULL
- phone — varchar2 — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
Employee (사원)
- id — number — Primary key — NOT NULL
- name — varchar2 — NOT NULL
- phone — varchar2 — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
Shipment_warehouse (창고)
- id — number — Primary key — NOT NULL
- code — varchar2 — NOT NULL
- name — varchar2 — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
estimate (견적서)
- id — number — Primary key — NOT NULL
- employee — number — Foreign key → Employee.id — NOT NULL
- client — number — Foreign key → Client.id — NOT NULL
- status — varchar2 — NOT NULL
- not_order_quantity — number — NOT NULL
- not_order_supply_price — number — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
estimate_product (견적서_품목)
- id — number — Primary key — NOT NULL
- product — number — Foreign key → product.id — NOT NULL
- estimate — number — Foreign key → estimate.id — NOT NULL
- quantity — number — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
order_estimate (주문서_견적서)
- id — number — Primary key — NOT NULL
- order_sheet — number — Foreign key → order_sheet.id — NOT NULL
- estimate — number — Foreign key → estimate.id — NOT NULL
- product — number — Foreign key → product.id — NOT NULL
- quantity — number — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
order_sale (판매_주문서)
- id — number — Primary key — NOT NULL
- order_sheet — number — Foreign key → order_sheet.id — NOT NULL
- product_sale — number — Foreign key → product_sale.id — NOT NULL
- product — number — Foreign key → product.id — NOT NULL
- quantity — number — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
order_sheet (주문서)
- id — number — Primary key — NOT NULL
- employee — number — Foreign key → Employee.id — NOT NULL
- id (id2) — number — Foreign key → Client.id — NOT NULL
- status — varchar2 — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
product (품목)
- id — number — Primary key — NOT NULL
- warehouse — number — Foreign key → Shipment_warehouse.id — NOT NULL
- name — varchar2 — NOT NULL
- standard — varchar2 — NOT NULL
- quantity — number — NOT NULL
- price — number — NOT NULL
- supply_price — varchar2 — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
product_sale (판매)
- id — number — Primary key — NOT NULL
- employee — number — Foreign key → Employee.id — NOT NULL
- id (id2) — number — Foreign key → Client.id — NOT NULL
- type — varchar2 — NOT NULL
- sale_date — date — NOT NULL
- created_at — date — NOT NULL
- updated_atu (updated_at) — date — NOT NULL
sale_si (판매_출하지시서)
- id — number — Primary key — NOT NULL
- product_sale — number — Foreign key → product_sale.id — NOT NULL
- shipping_instruction — number — Foreign key → shipping_instruction.id — NOT NULL
- product — number — Foreign key → product.id — NOT NULL
- quantity — number — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
shipping (출하)
- id — number — Primary key — NOT NULL
- employee — number — Foreign key → Employee.id — NOT NULL
- id (id2) — number — Foreign key → Client.id — NOT NULL
- address — varchar2 — NOT NULL
- phone — varchar2 — NOT NULL
- postal_code — varchar2 — NOT NULL
shipping_instruction (출하 지시서)
- id — number — Primary key — NOT NULL
- employee — number — Foreign key → Employee.id — NOT NULL
- id (id2) — number — Foreign key → Client.id — NOT NULL
- instruction_date — date — NOT NULL
- status — varchar2 — NOT NULL
- remarks — varchar2
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
si_shipping (출하_출하지시서)
- id — number — Primary key — NOT NULL
- shipping_instruction — number — Foreign key → shipping_instruction.id — NOT NULL
- shipping — number — Foreign key → shipping.id — NOT NULL
- product — number — Foreign key → product.id — NOT NULL
- quantity — number — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL