test
Tables (39)
access_log
- id — int8 — Primary key — NOT NULL
- event_time — timestamptz — Primary key — NOT NULL
- user_id — varchar(100)
- ip_address — inet
- service — varchar(100)
- action — varchar(50) — NOT NULL
- status — varchar(20) — NOT NULL
- request_id — uuid
- user_agent — text
- details — text
application_log
- id — int8 — Primary key — NOT NULL
- event_time — timestamptz — Primary key — NOT NULL
- user_id — varchar(100)
- ip_address — inet
- service — varchar(100) — NOT NULL
- action — varchar(100) — NOT NULL
- status — varchar(20) — NOT NULL
- request_id — uuid
- details — text
audit_log
- id — int8 — Primary key — NOT NULL
- event_time — timestamptz — Primary key — NOT NULL
- user_id — varchar(100) — NOT NULL
- ip_address — inet
- service — varchar(100)
- action — varchar(100) — NOT NULL
- resource — varchar(255) — NOT NULL
- status — varchar(20) — NOT NULL
- request_id — uuid
- details — text
auth_group
- id — serial4 — Primary key — NOT NULL
- name — varchar(150) — NOT NULL
auth_group_permissions
- id — bigserial — Primary key — NOT NULL
- group_id — int4 — NOT NULL
- permission_id — int4 — NOT NULL
auth_permission
- id — serial4 — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- content_type_id — int4 — NOT NULL
- codename — varchar(100) — NOT NULL
auth_user
- id — serial4 — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- last_login — timestamptz
- is_superuser — bool — NOT NULL
- username — varchar(150) — NOT NULL
- first_name — varchar(150) — NOT NULL
- last_name — varchar(150) — NOT NULL
- email — varchar(254) — NOT NULL
- is_staff — bool — NOT NULL
- is_active — bool — NOT NULL
- date_joined — timestamptz — NOT NULL
auth_user_groups
- id — bigserial — Primary key — NOT NULL
- user_id — int4 — NOT NULL
- group_id — int4 — NOT NULL
auth_user_user_permissions
- id — bigserial — Primary key — NOT NULL
- user_id — int4 — NOT NULL
- permission_id — int4 — NOT NULL
company
- id — serial4 — Primary key — NOT NULL
- name — varchar(150) — NOT NULL
- domain — varchar(150)
- address — text
- is_active — bool — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
company_group
- id — serial4 — Primary key — NOT NULL
- company_id — int4 — NOT NULL
- name — varchar(100) — NOT NULL
- description — text
- is_system — bool
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- data_lake_permission_code — varchar(50)
- preprocessing_permission_code — varchar(50)
- ml_permission_code — varchar(50)
data_preprocessing_status
- id — varchar(40) — Primary key — NOT NULL
- start_at — timestamptz — NOT NULL
- status — varchar(20) — NOT NULL
default_model_param
- id — serial4 — Primary key — NOT NULL
- model_name — varchar(50) — NOT NULL
- param_name — varchar(50) — NOT NULL
- param_value — varchar(100) — NOT NULL
- description — text
- created_at — timestamptz
- updated_at — timestamptz
django_admin_log
- id — serial4 — Primary key — NOT NULL
- action_time — timestamptz — NOT NULL
- object_id — text
- object_repr — varchar(200) — NOT NULL
- action_flag — int4 — NOT NULL
- change_message — text — NOT NULL
- content_type_id — int4
- user_id — int4 — NOT NULL
django_content_type
- id — serial4 — Primary key — NOT NULL
- app_label — varchar(100) — NOT NULL
- model — varchar(100) — NOT NULL
django_migrations
- id — bigserial — Primary key — NOT NULL
- app — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- applied — timestamptz — NOT NULL
django_session
- session_key — varchar(40) — Primary key — NOT NULL
- session_data — text — NOT NULL
- expire_date — timestamptz — NOT NULL
email_send_log
- id — serial4 — Primary key — NOT NULL
- email — varchar(254) — NOT NULL
- auth_code — varchar(20) — NOT NULL
- created_dt — timestamptz — NOT NULL
- verified — bool — NOT NULL
- verified_dt — timestamptz
feature_metadata
- id — serial4 — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- group_name — varchar(100)
- type — varchar(20)
- min — varchar(10)
- max — varchar(10)
- interval — varchar(10)
- example — varchar(200)
header_column
- id — serial4 — Primary key — NOT NULL
- columns — varchar(10000) — NOT NULL
- raw_file_id — int4 — NOT NULL
ml_manage
- id — serial4 — Primary key — NOT NULL
- user_name — varchar(150) — NOT NULL
- ml_task_id — varchar(150) — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- is_ml_running — bool
- current_status — varchar(50)
ml_manage_logistic_unique_group_id
- id — serial4 — Primary key — NOT NULL
- user_name — varchar(150) — NOT NULL
- ml_task_id — varchar(150) — NOT NULL
- group_name — varchar(150) — NOT NULL
- table_name — varchar(150)
- created_at — timestamptz — NOT NULL
ml_manage_preprocessing_info
- id — serial4 — Primary key — NOT NULL
- ml_manage_id — int4 — NOT NULL
- preprocessing_id — varchar(150) — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
ml_manage_test_unique_group_id
- id — serial4 — Primary key — NOT NULL
- user_name — varchar(150) — NOT NULL
- ml_task_id — varchar(150) — NOT NULL
- group_name — varchar(150) — NOT NULL
- table_name — varchar(150)
- created_at — timestamptz — NOT NULL
ml_manage_unique_model_id
- id — serial4 — Primary key — NOT NULL
- user_name — varchar(150) — NOT NULL
- ml_task_id — varchar(150) — NOT NULL
- group_name — varchar(150) — NOT NULL
- model_name — varchar(150) — NOT NULL
- table_name — varchar(150)
- created_at — timestamptz — NOT NULL
model_manage
- id — serial4 — Primary key — NOT NULL
- user_name — varchar(150) — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- group_name — varchar(150) — NOT NULL
- size — varchar(24)
- model_image — bytea
- model_setting — text
- is_favorite — bool — NOT NULL
- keyword — text
- description — text
permission_type
- id — serial4 — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- name — varchar(100) — NOT NULL
- description — text
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
preprocessing_complete_list
- id — serial4 — Primary key — NOT NULL
- user_name — varchar(150)
- table_name — varchar(250)
- original_table_name — varchar(250)
- size — varchar(24)
- description — varchar(100)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
preprocessing_status
- id — serial4 — Primary key — NOT NULL
- owner — varchar(150) — NOT NULL
- preprocessing_id — varchar(150) — NOT NULL
- project_id — int4
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- is_preprocessing_running — bool
- current_status — varchar(50)
project_manage
- id — serial4 — Primary key — NOT NULL
- project_name — varchar(30)
- keyword — text
- description — text
- owner — varchar(150) — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- size — varchar(24)
- report_image — bytea
- model_image — bytea
- is_favorite — bool — NOT NULL
- features — _text
project_manage_data_lake
- id — serial4 — Primary key — NOT NULL
- project_manage_id — int4 — NOT NULL
- upload_raw_data_file_id — int4 — NOT NULL
- created_at — timestamptz — NOT NULL
report_manage
- id — serial4 — Primary key — NOT NULL
- user_name — varchar(150) — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- group_name — varchar(150) — NOT NULL
- size — varchar(24)
- report_image — bytea
- report_setting — text
- is_favorite — bool — NOT NULL
- keyword — text
- description — text
template_feature
- id — serial4 — Primary key — NOT NULL
- template_name — varchar(200) — NOT NULL
- feature_name_id — int4 — NOT NULL
upload_chunk_file
- id — serial4 — Primary key — NOT NULL
- unique_file_name — varchar(100) — NOT NULL
- chunk_index — int4 — NOT NULL
- data — bytea — NOT NULL
- create_at — timestamptz — NOT NULL
upload_raw_data_file
- id — serial4 — Primary key — NOT NULL
- file_name — varchar(200) — NOT NULL
- file_type — varchar(10) — NOT NULL
- size — varchar(24) — NOT NULL
- owner — varchar(100) — NOT NULL
- load_type — varchar(10) — NOT NULL
- description — varchar(300)
- location — varchar(200) — NOT NULL
- create_at — timestamptz — NOT NULL
- update_at — timestamptz — NOT NULL
- is_preprocessing — bool — NOT NULL
- cleansing — varchar(1)
- standardization — varchar(1)
- is_create_table — bool — NOT NULL
upload_raw_data_file_record
- upload_raw_data_file_id — int4 — Primary key — NOT NULL
- user_id — int4 — NOT NULL
user
- id — serial4 — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- password — varchar(30) — NOT NULL
- create_at — timestamptz — NOT NULL
- email — varchar(254) — NOT NULL
- position — varchar(50) — NOT NULL
- update_at — timestamptz — NOT NULL
user_group_mapping
- id — serial4 — Primary key — NOT NULL
- user_id — int4 — NOT NULL
- company_id — int4 — NOT NULL
- company_group_id — int4 — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
user_profile
- id — serial4 — Primary key — NOT NULL
- user_id — int4
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- full_name — varchar(150)
- position — varchar(150)
- login_fail_count — int4 — NOT NULL
- lock_expires_at — timestamptz
- is_locked — bool — NOT NULL
- password_changed_at — timestamptz
- user_image — bytea
- company_id — int4 — NOT NULL