aaa

Tables (43)

as_is_analysis

  • id — bigserial — Primary key — NOT NULL
  • source_row_number — int4 — NOT NULL
  • as_is_gyeonghun — text
  • as_is_hwangcheol — text
  • process_sheet_name — text
  • source_data_name — text
  • data_description — text
  • data_type — text
  • author_department_a — text
  • author_department_b — text
  • work_method — text
  • file_or_system_path — text
  • deliverable_type_a — text
  • deliverable_type_b — text
  • changes_when_writing_pfc — text
  • cause — text
  • computerization_possible — text
  • bts_note — text
  • automation — text
  • pfc_type — text
  • is_used — text
  • imported_at — timestamptz — NOT NULL

bpfc

  • id — bigserial — Primary key — NOT NULL
  • product_code — text
  • colorway — text
  • dev_style — text
  • dpa_td_code — text
  • factory_code — text
  • source_file_id — int8 — Foreign key → files.id
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

bpfc_sheets

  • id — bigserial — Primary key — NOT NULL
  • parent_id — int8 — Foreign key → bpfc.id — NOT NULL
  • sheet_index — int4 — NOT NULL
  • sheet_name — text — NOT NULL
  • sheet_type — text — NOT NULL
  • page — text
  • is_hidden — bool — NOT NULL
  • doc — jsonb — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

cs_pfc

  • id — varchar(32) — Primary key — NOT NULL
  • _number — varchar(255) — NOT NULL
  • keyed_name — varchar(512)
  • synced_at — timestamptz — NOT NULL
  • _colorway — varchar(255)
  • _round — varchar(255)
  • _season — varchar(255)
  • _dev_style — varchar(255)
  • _product_code — varchar(255)
  • _ver — varchar(255)

cs_pfc_detail

  • id — serial4 — Primary key — NOT NULL
  • pfc_number — varchar(255) — Foreign key → cs_pfc._number — NOT NULL
  • _page — varchar(64) — NOT NULL
  • _name — varchar(512)
  • _json — jsonb
  • synced_at — timestamptz — NOT NULL

cs_pfc_stitching

  • id — int8
  • pfc_number — text
  • _page — text
  • _name — text
  • mctype — text
  • webbing — text
  • apparatus — text
  • needlesize — text
  • description — text
  • lacingholes — text
  • neddlepoint — text
  • neddlesystem — text
  • componentname — text
  • stitchinglines — text
  • attachingmethod — text
  • stitchingguideline — text

csg_cutting_layers

  • id — bigserial — Primary key — NOT NULL
  • document_name — text — NOT NULL
  • document_version — text — NOT NULL
  • revision — int4 — NOT NULL
  • general_row_count — int4 — NOT NULL
  • foam_row_count — int4 — NOT NULL
  • checksum_sha256 — text — NOT NULL
  • source_file_id — int8 — Foreign key → files.id
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

csg_cutting_layers_sheets

  • id — bigserial — Primary key — NOT NULL
  • parent_id — int8 — Foreign key → csg_cutting_layers.id — NOT NULL
  • sheet_name — text — NOT NULL
  • doc — jsonb — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

ctq_ctp

  • id — bigserial — Primary key — NOT NULL
  • document_version — text — NOT NULL
  • revision — int4 — NOT NULL
  • _season_cd — text
  • _dev_style_name — text
  • _style_cd — text
  • stage — text
  • factory_cd — text
  • last_code — text
  • td_code — text
  • gender — text
  • checksum_sha256 — text — NOT NULL
  • source_file_id — int8
  • source_format — text — NOT NULL
  • converted_from_legacy — bool — NOT NULL
  • slide_width — int8 — NOT NULL
  • slide_height — int8 — NOT NULL
  • slide_count — int4 — NOT NULL
  • table_count — int4 — NOT NULL
  • image_count — int4 — NOT NULL
  • attachment_count — int4 — NOT NULL
  • feature_count — int4 — NOT NULL
  • summary_metadata — jsonb — NOT NULL
  • structured_doc — jsonb — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

ctq_ctp_slides

  • id — bigserial — Primary key — NOT NULL
  • parent_id — int8 — Foreign key → ctq_ctp.id — NOT NULL
  • slide_number — int4 — NOT NULL
  • feature_number — int4
  • title — text
  • section_type — text — NOT NULL
  • doc — jsonb — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

department

  • department_id — bigserial — Primary key — NOT NULL
  • department_name — varchar(100) — NOT NULL
  • parent_department_id — int8 — Foreign key → department.department_id
  • sort_order — int4
  • is_active — bool — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

files

  • id — bigserial — NOT NULL
  • storage_path — text — NOT NULL
  • file_name — varchar(255)
  • original_filename — varchar(255)
  • file_extension — varchar(20)
  • mime_type — varchar(127)
  • file_size_bytes — int8
  • checksum_sha256 — varchar(64)
  • entity_type — varchar(50)
  • entity_id — int8
  • file_role — varchar(20)
  • uploaded_by — varchar(100)
  • created_at — timestamptz — NOT NULL

ids

  • id — bigserial — NOT NULL
  • document_name — text — NOT NULL
  • source_file_id — int8
  • original_filename — text — NOT NULL
  • checksum_sha256 — text — NOT NULL
  • file_size_bytes — int8
  • width — int4
  • height — int4
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • model — text
  • prod_code — text
  • location — text
  • date_tested — text
  • last — text
  • spec_size — text
  • spec_length — text
  • spec_gender — text

ids_detail

  • id — bigserial — NOT NULL
  • ids_id — int8 — NOT NULL
  • table_name — text — NOT NULL
  • row_type — text
  • shoe_size — numeric
  • average_mm — numeric
  • st_dev — numeric
  • cov_percent — numeric
  • max_mm — numeric
  • min_mm — numeric
  • range_mm — numeric
  • n — int4
  • sort_order — int4 — NOT NULL
  • created_at — timestamptz — NOT NULL

key_manufacturing_process

  • id — bigserial — Primary key — NOT NULL
  • document_name — text — NOT NULL
  • document_version — text — NOT NULL
  • revision — int4 — NOT NULL
  • sheet_count — int4 — NOT NULL
  • checksum_sha256 — text — NOT NULL
  • source_file_id — int8 — Foreign key → files.id
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

key_manufacturing_process_sheets

  • id — bigserial — Primary key — NOT NULL
  • parent_id — int8 — Foreign key → key_manufacturing_process.id — NOT NULL
  • sheet_name — text — NOT NULL
  • doc — jsonb — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

last_spec_chart

  • id — bigserial — NOT NULL
  • document_version — text — NOT NULL
  • revision — int4 — NOT NULL
  • last_code_raw — text
  • last_code — text
  • nike_x_code — text
  • gender — text
  • model_size — text
  • model_width — text
  • last_date_raw — text
  • last_date — date
  • developed_by — text
  • sockliner_allowance — text
  • core_heel_allowance — text
  • core_ball_allowance — text
  • upper_mtrl_prop — text
  • heel_ball_offset — text
  • heel_template — text
  • toe_template — text
  • last_bottom — text
  • base_chassis_last — text
  • toe_spring — text
  • bottom_width_grade — text
  • toe_shape — text
  • toe_width — text
  • toe_profile — text
  • cross_rocker — text
  • bottom_shape — text
  • commercialized_by — text
  • vendor_model — text
  • nike_le_responsible — text
  • requesting_group — text
  • requesting_person — text
  • hover_bh_loc_info — text
  • location_method — text
  • comments — text
  • heel_height — text
  • lbp_grade — numeric(20, 6)
  • ball_girth_grade — numeric(20, 6)
  • instep_g_div_ball_g — numeric(20, 6)
  • instep_girth_grade — numeric(20, 6)
  • long_heel_girth_grade — numeric(20, 6)
  • waist_g_div_ball_g — numeric(20, 6)
  • waist_girth_grade — numeric(20, 6)
  • sticklen_div_lbp_len — numeric(20, 6)
  • lbp_width_grade — numeric(20, 6)
  • model_instep — text
  • toe_spring_grade — numeric(20, 6)
  • hbo_grade — numeric(20, 6)
  • unrst_sticklen_grade — numeric(20, 6)
  • lbp_w_div_ball_g — numeric(20, 6)
  • unrst_sticklen_value — numeric(20, 6)
  • lbp_value — numeric(20, 6)
  • hbo_value — numeric(20, 6)
  • toe_spring_value — numeric(20, 6)
  • lbp_width_value — numeric(20, 6)
  • ball_girth_value — numeric(20, 6)
  • long_heel_girth_value — numeric(20, 6)
  • source_file_id — int8
  • created_by — text — NOT NULL
  • … +3

last_spec_chart_sheets

  • id — bigserial — NOT NULL
  • parent_id — int8 — NOT NULL
  • sheet_name — text — NOT NULL
  • doc — jsonb — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

last_spec_chart_size_rows

  • id — bigserial — NOT NULL
  • parent_id — int8 — NOT NULL
  • size_label — text — NOT NULL
  • size_num — numeric(8, 3)
  • stick_length_mm — numeric(20, 6)
  • lbp_length_mm — numeric(20, 6)
  • heel_ball_offset_mm — numeric(20, 6)
  • toe_spring_mm — numeric(20, 6)
  • lbp_width_mm — numeric(20, 6)
  • ball_girth_mm — numeric(20, 6)
  • waist_girth_mm — numeric(20, 6)
  • instep_girth_mm — numeric(20, 6)
  • long_heel_girth_mm — numeric(20, 6)
  • ngcd_min — numeric(20, 6)
  • ngcd_target — numeric(20, 6)
  • ngcd_max — numeric(20, 6)
  • ball_width_pct_of_ball_girth — numeric(20, 6)
  • ngcd_grade_per_half_size — numeric(20, 6)
  • ngcd_grade_per_whole_size — numeric(20, 6)
  • source_row — int4
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

menu

  • menu_id — bigserial — Primary key — NOT NULL
  • menu_name — varchar(100) — NOT NULL
  • parent_menu_id — int8 — Foreign key → menu.menu_id
  • sort_order — int4
  • is_active — bool — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • icon — varchar(50)

menu_item

  • menu_item_id — bigserial — Primary key — NOT NULL
  • menu_id — int8 — Foreign key → menu.menu_id — NOT NULL
  • item_name — varchar(100) — NOT NULL
  • screen_url — varchar(200)
  • sort_order — int4
  • is_active — bool — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

oia

  • id — bigserial — Primary key — NOT NULL
  • title — text — NOT NULL
  • update_label — text
  • document_version — text — NOT NULL
  • revision — int4 — NOT NULL
  • checksum_sha256 — text — NOT NULL
  • source_file_id — int8 — Foreign key → files.id
  • unit_count — int4 — NOT NULL
  • spec_count — int4 — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

oia_specs

  • id — bigserial — Primary key — NOT NULL
  • unit_id — int8 — Foreign key → oia_units.id — NOT NULL
  • sku — text — NOT NULL
  • associated_carton_skus — _text
  • description — text
  • inside_length_mm — numeric
  • inside_width_mm — numeric
  • inside_height_mm — numeric
  • outside_length_mm — numeric
  • outside_width_mm — numeric
  • outside_height_mm — numeric
  • weight_g — numeric
  • net_weight_kg — numeric
  • pack_count — int4
  • carton_type_code — text
  • accessory_length_mm — numeric
  • accessory_width_mm — numeric
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

oia_units

  • id — bigserial — Primary key — NOT NULL
  • parent_id — int8 — Foreign key → oia.id — NOT NULL
  • oia_project_number — text — NOT NULL
  • mtl_number — text — NOT NULL
  • section_type — text — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

outsole_waste

  • id — bigserial — Primary key — NOT NULL
  • document_name — text — NOT NULL
  • document_version — text — NOT NULL
  • revision — int4 — NOT NULL
  • sheet_count — int4 — NOT NULL
  • checksum_sha256 — text — NOT NULL
  • source_file_id — int8 — Foreign key → files.id
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

outsole_waste_sheets

  • id — bigserial — Primary key — NOT NULL
  • parent_id — int8 — Foreign key → outsole_waste.id — NOT NULL
  • sheet_name — text — NOT NULL
  • doc — jsonb — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

per

  • id — bigserial — Primary key — NOT NULL
  • style_name — text — NOT NULL
  • revision — int4 — NOT NULL
  • pattern_count — int4 — NOT NULL
  • image_count — int4 — NOT NULL
  • checksum_sha256 — text — NOT NULL
  • source_file_id — int8 — Foreign key → files.id
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

per_patterns

  • id — bigserial — Primary key — NOT NULL
  • parent_id — int8 — Foreign key → per.id — NOT NULL
  • block_index — int4 — NOT NULL
  • source_row — int4 — NOT NULL
  • pattern_raw — text — NOT NULL
  • pattern_code — text
  • pattern_name — text
  • material — text
  • size_fitting — text
  • fitting_mark — text
  • gap_value — numeric(20, 6)
  • gap_unit — text
  • efficiency_pct — numeric(9, 4)
  • waste_pct — numeric(9, 4)
  • yield_per_pair — numeric(20, 8)
  • yield_unit — text
  • layout_image_file_id — int8 — Foreign key → files.id
  • doc — jsonb — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

permission

  • permission_id — bigserial — Primary key — NOT NULL
  • permission_code — varchar(50) — NOT NULL
  • permission_name — varchar(100) — NOT NULL
  • menu_item_id — int8 — Foreign key → menu_item.menu_item_id — NOT NULL
  • action_code — varchar(10) — NOT NULL
  • is_active — bool — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

product_exception

  • id — bigserial — NOT NULL
  • document_version — text — NOT NULL
  • revision — int4 — NOT NULL
  • _season_cd — text
  • _dev_style_name — text
  • _style_cd — text
  • _product_code — text
  • source_file_id — int8
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

product_exception_sheets

  • id — bigserial — NOT NULL
  • parent_id — int8 — NOT NULL
  • sheet_name — text — NOT NULL
  • doc — jsonb — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

project_file

  • id — bigserial — Primary key — NOT NULL
  • document_version — text — NOT NULL
  • revision — int4 — NOT NULL
  • _season_cd — text
  • _dev_style_name — text
  • _style_cd — text
  • stage — text
  • factory_cd — text
  • pcc_cd — text
  • last_code — text
  • lead_colorway_id — text
  • td_code — text
  • template_version — text
  • checksum_sha256 — text — NOT NULL
  • source_file_id — int8
  • slide_count — int4 — NOT NULL
  • table_count — int4 — NOT NULL
  • image_count — int4 — NOT NULL
  • attachment_count — int4 — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • structured_doc — jsonb — NOT NULL

project_file_slides

  • id — bigserial — Primary key — NOT NULL
  • parent_id — int8 — Foreign key → project_file.id — NOT NULL
  • slide_number — int4 — NOT NULL
  • title — text
  • section_type — text — NOT NULL
  • doc — jsonb — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

rfc_memo

  • id — bigserial — Primary key — NOT NULL
  • identifier — text — NOT NULL
  • memo_type — text — NOT NULL
  • model_name — text
  • revision — int4 — NOT NULL
  • image_count — int4 — NOT NULL
  • checksum_sha256 — text — NOT NULL
  • source_file_id — int8 — Foreign key → files.id
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

rfc_memo_content

  • id — bigserial — Primary key — NOT NULL
  • parent_id — int8 — Foreign key → rfc_memo.id — NOT NULL
  • doc — jsonb — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

role

  • role_id — bigserial — Primary key — NOT NULL
  • role_name — varchar(100) — NOT NULL
  • description — varchar(500)
  • is_active — bool — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

role_permission

  • permission_id — int8 — Foreign key → permission.permission_id — NOT NULL
  • role_id — int8 — Foreign key → role.role_id — NOT NULL
  • created_at — timestamptz — NOT NULL

toebox

  • id — bigserial — Primary key — NOT NULL
  • title — text — NOT NULL
  • update_date — date
  • document_version — text — NOT NULL
  • revision — int4 — NOT NULL
  • checksum_sha256 — text — NOT NULL
  • source_file_id — int8
  • slide_count — int4 — NOT NULL
  • table_count — int4 — NOT NULL
  • row_count — int4 — NOT NULL
  • structured_doc — jsonb — NOT NULL
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

toebox_conditions

  • id — bigserial — Primary key — NOT NULL
  • parent_id — int8 — Foreign key → toebox.id — NOT NULL
  • vendor — text — NOT NULL
  • material_name — text — NOT NULL
  • plate_temp_min_c — numeric(6, 2)
  • plate_temp_max_c — numeric(6, 2)
  • interface_temp_min_c — numeric(6, 2)
  • interface_temp_max_c — numeric(6, 2)
  • press_time_min_s — numeric(6, 2)
  • press_time_max_s — numeric(6, 2)
  • machine_type — text
  • source_row — int4
  • created_by — text — NOT NULL
  • updated_by — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

tooling_bol

  • id — bigserial — NOT NULL
  • document_version — varchar(20)
  • revision — int4 — NOT NULL
  • _season_cd — varchar(256)
  • _dev_style_name — varchar(1000)
  • _model_cd — varchar(32)
  • _style_cd — varchar(20)
  • source_file_id — int8 — NOT NULL
  • created_by — varchar(100)
  • updated_by — varchar(100)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • document_name — text — NOT NULL

tooling_bol_sheets

  • id — bigserial — NOT NULL
  • parent_id — int8 — NOT NULL
  • sheet_name — varchar(200)
  • doc — jsonb — NOT NULL
  • created_by — varchar(100)
  • updated_by — varchar(100)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

user_role

  • role_id — int8 — Foreign key → role.role_id — NOT NULL
  • user_id — int8 — Foreign key → users.id — NOT NULL
  • granted_at — timestamptz — NOT NULL

users

  • id — bigserial — Primary key — NOT NULL
  • email — text — NOT NULL
  • password_hash — text — NOT NULL
  • display_name — text — NOT NULL
  • is_active — bool — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • department_id — int8 — Foreign key → department.department_id