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