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