db subject
테이블 (17)
Untitled (DeliveryLine)
- Key (delivery_line_id) — VARCHAR(20) — 기본 키 — NOT NULL
- Key (delivery_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (line_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (delivered_quantity) — INT
- Field (inspection_result) — VARCHAR(20)
- Field (inspection_note) — TEXT
Untitled (Permission)
- Key (permission_id) — VARCHAR(20) — 기본 키 — NOT NULL
- Field (permission_name) — VARCHAR(255)
- Field (resource_type) — VARCHAR(255)
- Field (action_type) — VARCHAR(255)
Untitled (RolePermisson)
- Key (role_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (permission_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (UserRole)
- Key (user_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (role_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Role)
- Key (role_id) — VARCHAR(20) — 기본 키 — NOT NULL
- Field (role_name) — VARCHAR(255)
Untitled (User)
- Key (user_id) — VARCHAR(20) — 기본 키 — NOT NULL
- Field (name) — VARCHAR(255)
- Field (email) — VARCHAR(255)
- Field (user_type) — VARCHAR(20)
Untitled (CarbonEmissionRecord)
- Key (emission_id) — VARCHAR(20) — 기본 키 — NOT NULL
- Key (delivery_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- ID (project_id) — VARCHAR(20) — 외래 키 → 선박 프로젝트.ID — NOT NULL
- Field (emission_type) — VARCHAR(255)
- Field (co2e_amount) — DECIMAL(15, 4)
- Field (calculation_standard) — VARCHAR(255)
- Field (record_date) — DATE
- Field (notes) — TEXT
Untitled (Inventory)
- Key (inventory_id) — VARCHAR(20) — 기본 키 — NOT NULL
- Key (part_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (warehouse_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (quantity) — INT
- Field (last_updated) — DATETIME
Untitled (Warehouse)
- Key (warehouse_id) — VARCHAR(20) — 기본 키 — NOT NULL
- ID (shipyard_id) — VARCHAR(20) — 외래 키 → 조선소.ID — NOT NULL
- Field (name) — VARCHAR(255)
- Field (location) — VARCHAR(255)
- Field (temperature_controlled) — BOOLEAN
Untitled (Delivery)
- Key (delivery_id) — VARCHAR(20) — 기본 키 — NOT NULL
- Key (order_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (actual_arrival_date) — DATE
- Field (transport_method) — VARCHAR(255)
- Field (transport_distance) — DECIMAL(10, 2)
- Field (delivery_status) — VARCHAR(20)
Untitled (PurchaseOrderLine)
- Key (line_id) — VARCHAR(20) — 기본 키 — NOT NULL
- Key (order_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (part_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (quantity) — INT
- Field (unit_price) — DECIMAL(15, 2)
- Field (requested_delivery_date) — DATE
Untitled (PurchaseOrder)
- Key (order_id) — VARCHAR(20) — 기본 키 — NOT NULL
- ID (project_id) — VARCHAR(20) — 외래 키 → 선박 프로젝트.ID — NOT NULL
- Key (supplier_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (order_date) — DATE
- Field (order_status) — VARCHAR(20)
- Field (engineer_in_charge) — VARCHAR(255)
Untitled (Part_Supplier)
- Key (part_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (supplier_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (unit_price) — DECIMAL(15, 2)
- Field (lead_time) — INT
- Field (min_order_quantity) — INT
Untitled (Supplier)
- Key (supplier_id) — VARCHAR(20) — 기본 키 — NOT NULL
- Field (name) — VARCHAR(255)
- Field (country) — VARCHAR(255)
- Field (contact_person) — VARCHAR(255)
- Field (contact_number) — VARCHAR(255)
- Field (esg_grade) — VARCHAR(1)
Untitled (Part)
- Key (part_id) — VARCHAR(20) — 기본 키 — NOT NULL
- Field (name) — VARCHAR(255)
- Field (specification) — VARCHAR(255)
- Field (unit) — VARCHAR(255)
- Field (carbon_emission_factor) — DECIMAL(10, 4)
선박 프로젝트 (ShipProject)
- ID (project_id) — VARCHAR(20) — 기본 키 — NOT NULL
- ID (shipyard_id) — VARCHAR(20) — 외래 키 → 조선소.ID — NOT NULL
- Field (ship_name) — VARCHAR(100)
- Field (ship_type) — VARCHAR(100)
- Field (contract_date) — DATE
- Field (expected_delivery_date) — DATE
- Field (status) — VARCHAR(20)
조선소 (Shipyard)
- ID (shipyard_id) — VARCHAR(20) — 기본 키 — NOT NULL
- 이름 (name) — VARCHAR(100)
- 지역 (region) — VARCHAR(100)
- 담당본부명 (division_name) — VARCHAR(100)
- 설립일 (established_date) — DATE