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