jo3

Tables (14)

OEM

  • id — bigint — Primary key — NOT NULL
  • name — VARCHAR(255)

OEM_PLANT

  • id — bigint — Primary key — NOT NULL
  • name — VARCHAR(255)
  • state_id — bigint — Foreign key → state.id — NOT NULL

car_name

  • id — bigint — Primary key — NOT NULL
  • name — VARCHAR(255)

car_type

  • id — bigint — Primary key — NOT NULL
  • name — VARCHAR(255)
  • year — VARCHAR(255)
  • volume — bigint
  • fuel_id — bigint — Foreign key → fuel.id — NOT NULL
  • platform_id — bigint — Foreign key → platform.id — NOT NULL
  • oem_id — bigint — Foreign key → OEM.id — NOT NULL
  • car_name_id — bigint — Foreign key → car_name.id — NOT NULL
  • oem_plant_id — bigint — Foreign key → OEM_PLANT.id — NOT NULL

company

  • id — bigint — Primary key — NOT NULL
  • name — VARCHAR(255)

contract

  • id — bigint — Primary key — NOT NULL
  • company_id — bigint — Foreign key → company.id — NOT NULL
  • item_id — bigint — Foreign key → item.id — NOT NULL
  • status_id — int — Foreign key → status.id — NOT NULL

daeheung_plant

  • id — bigint — Primary key — NOT NULL
  • name — VARCHAR(255)

fuel

  • id — bigint — Primary key — NOT NULL
  • name — VARCHAR(255)

item

  • id — bigint — Primary key — NOT NULL
  • price — bigint
  • name — VARCHAR(255)
  • sub_category_id — bigint — Foreign key → sub_category.id — NOT NULL
  • car_type_id — bigint — Foreign key → car_type.id — NOT NULL

main_category

  • id — bigint — Primary key — NOT NULL
  • name — VARCHAR(255)

platform

  • id — bigint — Primary key — NOT NULL
  • name — VARCHAR(255)

state

  • id — bigint — Primary key — NOT NULL
  • name — VARCHAR(255)

status

  • id — int — Primary key — NOT NULL
  • name — VARCHAR(255)
  • daeheung_plant_id — bigint — Foreign key → daeheung_plant.id — NOT NULL

sub_category

  • id — bigint — Primary key — NOT NULL
  • name — VARCHAR(255)
  • main_category_id — bigint — Foreign key → main_category.id — NOT NULL