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