vision
Tables (21)
dsd_user (postgreSQL) (dsd_user)
- id — uuid — NOT NULL — type : char(36) -> uuid
- email — varchar(255)
- password — varchar(255) — NOT NULL — name : hashed_password -> password
- status — varchar(12) — NOT NULL — (ENUM TYPE)
- dsd_group — varchar(7) — NOT NULL — (ENUM TYPE) name : group -> dsd_group
- dsd_role — varchar(6) — NOT NULL — (ENUM TYPE) name : role -> dsd_role
- nickname — varchar(50) — NOT NULL
- username — varchar(50) — NOT NULL
- picture_url — jsonb — type : json -> jsonb
- birthday — integer — name : birth_day -> birthday
- phone_number — varchar(255) — NOT NULL
- phone_verification_datetime — timestamp — type : datetime(6) -> timestamp
- join_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- last_updated_datetime — timestamp — type : datetime(6) -> timestamp
- first_login_datetime — timestamp — type : datetime(6) -> timestamp
- nickname_modification_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- last_login_datetime — timestamp — type : datetime(6) -> timestamp
- last_activate_datetime — timestamp — type : datetime(6) -> timestamp
- leave_datetime — timestamp — type : datetime(6) -> timestamp
- dormancy_datetime — timestamp — type : datetime(6) -> timestamp
- extra_detail — jsonb — type : json -> jsonb
- sns_accounts — jsonb — type : json -> jsonb
- comment — text — type : longtext -> text
- background_image_url — jsonb — type : json -> jsonb
- c_phone_number — varchar(50)
- income_type — varchar(12) — (ENUM TYPE)
- created_datetime — timestamp — NOT NULL — 새로 추가된 컬럼
- updated_datetime — timestamp — 새로 추가된 컬럼
nice_api_bank_code (postgreSQL) (nice_api_bank_code)
- id — bigint — NOT NULL
- bank_alias — varchar(255) — NOT NULL
- bank_code — varchar(255) — NOT NULL
- bank_name — varchar(255) — NOT NULL
- is_active — boolean — NOT NULL
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp
phone_number_verification (postgreSQL) (phone_number_verification)
- id — uuid — NOT NULL — type : char(36) -> uuid
- hashed_phone_number — varchar(60) — NOT NULL
- code — varchar(6)
- register_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- expired_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- confirm_status — varchar(9) — NOT NULL — (ENUM TYPE)
- service_provider — varchar(8) — (ENUM TYPE)
- verification_data — varchar(100)
- created_datetime — timestamp — NOT NULL — 새로 추가된 컬럼
- updated_datetime — timestamp — 새로 추가된 컬럼
point (postgreSQL) (point)
- id — bigint — NOT NULL
- name — varchar(100) — NOT NULL
- amount — integer — NOT NULL
- point_status — varchar(10) — NOT NULL — (ENUM TYPE)
- income_type — varchar(22) — NOT NULL — (ENUM TYPE)
- income_standard — varchar(7) — NOT NULL — (ENUM TYPE)
- payment_type — varchar(14) — NOT NULL — (ENUM TYPE)
- payment_id — varchar(24)
- payment_reason_title — varchar(100)
- recall_type — varchar(17) — (ENUM TYPE)
- is_deleted — boolean — NOT NULL — type : tinyint(1) -> boolean
- created_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- updated_datetime — timestamp — type : datetime(6) -> timestamp
- deleted_datetime — timestamp — type : datetime(6) -> timestamp
- scheduled_datetime — timestamp — type : datetime(6) -> timestamp
- payment_datetime — timestamp — type : datetime(6) -> timestamp
- recall_datetime — timestamp — type : datetime(6) -> timestamp
- expire_datetime — timestamp — type : datetime(6) -> timestamp
- expired_datetime — timestamp — type : datetime(6) -> timestamp
- user_id — uuid
- payment_title_image_url — varchar(512)
- is_fake — boolean — NOT NULL — type : tinyint(1) -> boolean
point_history (postgreSQL) (point_history)
- id — bigint — NOT NULL
- history_type — varchar(20) — NOT NULL — (ENUM TYPE)
- reason — varchar(100)
- detail_reason — varchar(100)
- created_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- scheduled_datetime — timestamp — type : datetime(6) -> timestamp
- admin_comment — text — type : longtext -> text
- admin_manager — varchar(100)
- point_id — bigint
- updated_datetime — timestamp — 새로 추가된 컬럼
reserved_username (postgreSQL) (reserved_username)
- id — bigint — NOT NULL
- name — varchar(50)
- register_datetime — timestamp — type : datetime(6) -> timestamp
- is_released — boolean — NOT NULL — type : tinyint(1) -> boolean
- released_datetime — timestamp — type : datetime(6) -> timestamp
- user_id — uuid
- created_datetime — timestamp — NOT NULL — 새로 추가된 컬럼
- updated_datetime — timestamp — 새로 추가된 컬럼
reward_history (postgreSQL) (reward_history)
- id — bigint — NOT NULL
- history_type — varchar(10) — NOT NULL — (ENUM TYPE)
- created_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- updated_datetime — timestamp — type : datetime(6) -> timestamp
- point_history_id — bigint
- user_id — uuid
- withdrawal_id — bigint
session_track (postgreSQL) (session_track)
- id — bigint — NOT NULL
- track_id — varchar(300) — NOT NULL
- register_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- last_updated_datetime — timestamp — type : datetime(6) -> timestamp
- is_deleted — boolean — NOT NULL — type : tinyint(1) -> boolean
- deleted_datetime — timestamp — type : datetime(6) -> timestamp
- user_id — uuid
- created_datetime — timestamp — NOT NULL — 새로 추가된 컬럼
- updated_datetime — timestamp — 새로 추가된 컬럼
settlement (postgreSQL) (settlement)
- id — bigint — NOT NULL
- settlement_status — varchar(9) — NOT NULL — (ENUM TYPE)
- taxable — boolean — NOT NULL — type : tinyint(1) -> boolean
- income_tax — integer — NOT NULL
- local_income_tax — integer — NOT NULL
- krw_amount — integer — NOT NULL
- krw_amount_without_tax — integer — NOT NULL
- settled_krw_amount — integer
- depositor_name — varchar(100) — NOT NULL
- requested_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- completed_datetime — timestamp — type : datetime(6) -> timestamp
- complete_reserved_datetime — timestamp — type : datetime(6) -> timestamp
- created_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- updated_datetime — timestamp — type : datetime(6) -> timestamp
- admin_comment — text — type : longtext -> text
- admin_manager — varchar(100)
- point_id — bigint
- user_id — uuid
- withdrawal_id — bigint
settlement_history (postgreSQL) (settlement_history)
- id — bigint — NOT NULL
- history_type — varchar(9) — NOT NULL — (ENUM TYPE)
- created_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- reason — varchar(100)
- detail_reason — varchar(100)
- settlement_id — bigint
- updated_datetime — timestamp — 새로 추가된 컬럼
temp_user_device_invalid_token (postgreSQL) (temp_user_device_invalid_token)
- id — varchar(255) — NOT NULL
- user_id — uuid
- fcm_token — varchar(255)
- device_type — varchar(50) — NOT NULL — (ENUM TYPE)
- inserted_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
user_attribute (postgreSQL) (user_attribute)
- id — bigint — NOT NULL — type : int -> bigint
- attr — vharchar(20) — (ENUM TYPE)
- is_deleted — boolean — type : tinyint(1) -> boolean
- register_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- deleted_datetime — timestamp — type : datetime(6) -> timestamp
- user_id — uuid
- created_datetime — timestamp — NOT NULL — 새로 추가된 컬럼
- updated_datetime — timestamp — 새로 추가된 컬럼
user_attribute_history (postgreSQL) (user_attribute_history)
- id — bigint — NOT NULL
- activity_start_datetime — timestamp — type : datetime(6) -> timestamp
- activity_end_datetime — timestamp — type : datetime(6) -> timestamp
- created_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- updated_datetime — timestamp — type : datetime(6) -> timestamp
- user_attribute_id — bigint
user_device (postgreSQL) (user_device)
- id — bigint — NOT NULL
- device_token — varchar(500)
- is_deleted — boolean — NOT NULL — type : tinyint(1) -> boolean
- register_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- deleted_datetime — timestamp — type : datetime(6) -> timestamp
- user_id — uuid
- fcm_token — varchar(500)
- device_type — varchar(10) — NOT NULL — (ENUM TYPE)
- created_datetime — timestamp — NOT NULL — 새로 추가된 컬럼
- updated_datetime — timestamp — 새로 추가된 컬럼
- version — bigint — NOT NULL — 새로 추가된 컬럼
user_identification_stage (postgreSQL) (user_identification_stage)
- id — uuid — NOT NULL — type : char(36) -> uuid
- c_real_name — varchar(100)
- c_birthday — varchar(100)
- c_gender_code — varchar(100)
- c_phone_number — varchar(100)
- c_social_security_number — varchar(100)
- mobile_carrier_code — varchar(5)
- created_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- expired_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- is_removed — boolean — NOT NULL — type : tinyint(1) -> boolean
- removed_datetime — timestamp — type : datetime(6) -> timestamp
- user_id — uuid
- updated_datetime — timestamp — 새로 추가된 컬럼
user_invitation (postgreSQL) (user_invitation)
- id — bigint — NOT NULL
- code — varchar(30) — NOT NULL
- is_reusable — boolean — NOT NULL — type : tinyint(1) -> boolean
- is_deleted — boolean — NOT NULL — type : tinyint(1) -> boolean
- expired_datetime — timestamp — type : datetime(6) -> timestamp
- confirm_status — varchar(9) — NOT NULL — (ENUM TYPE)
- confirm_datetime — timestamp — type : datetime(6) -> timestamp
- user_id — uuid
- is_private — boolean — NOT NULL — type : tinyint(1) -> boolean
- created_datetime — timestamp — NOT NULL — 새로 추가된 컬럼
- updated_datetime — timestamp — 새로 추가된 컬럼
user_privacy (postgreSQL) (user_privacy)
- id — bigint — NOT NULL
- c_real_name — varchar(100)
- masked_real_name — varchar(50)
- c_birthday — varchar(100)
- c_gender_code — varchar(100)
- c_phone_number — varchar(100)
- mobile_carrier_code — varchar(5)
- bank_code — varchar(10)
- bank_name — varchar(15)
- c_bank_account_holder_name — varchar(100)
- masked_bank_account_holder_name — varchar(50)
- c_bank_account_number — varchar(100)
- masked_bank_account_number — varchar(50)
- is_ready_bank_account — boolean — NOT NULL — type : tinyint(1) -> boolean
- is_error_bank_account — boolean — NOT NULL — type : tinyint(1) -> boolean
- created_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- updated_datetime — timestamp — type : datetime(6) -> timestamp
- user_id — uuid
user_term (postgreSQL) (user_term)
- id — bigint — NOT NULL
- service_policy_version — varchar(10) — NOT NULL — user 에서 분리된 컬럼
- service_policy_agreement_datetime — timestamp — user 에서 분리된 컬럼 / type : datetime(6) -> timestamp
- privacy_policy_version — varchar(10) — NOT NULL — user 에서 분리된 컬럼
- privacy_policy_agreement_datetime — timestamp — user 에서 분리된 컬럼 / type : datetime(6) -> timestamp
- community_guideline_agreement_datetime — timestamp — user 에서 분리된 컬럼 / type : datetime(6) -> timestamp
- age_limit_agreement_datetime — timestamp — user 에서 분리된 컬럼 / type : datetime(6) -> timestamp
- marketing_service_agreement_datetime — timestamp — user 에서 분리된 컬럼 / type : datetime(6) -> timestamp
- reward_program_agreement_datetime — timestamp — user 에서 분리된 컬럼 / type : datetime(6) -> timestamp
- reward_program_agreement_rejected_datetime — timestamp — user 에서 분리된 컬럼 / type : datetime(6) -> timestamp
- user_id — uuid
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp
withdrawal (postgreSQL) (withdrawal)
- id — bigint — NOT NULL
- title — varchar(100) — NOT NULL
- requested_point_amount — integer — NOT NULL
- settled_krw_amount — integer — NOT NULL
- withdrawal_status — varchar(9) — NOT NULL — (ENUM TYPE)
- is_confirmed — boolean — NOT NULL — type : tinyint(1) -> boolean
- taxable — boolean — NOT NULL — type : tinyint(1) -> boolean
- requested_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- confirmed_datetime — timestamp — type : datetime(6) -> timestamp
- rejected_datetime — timestamp — type : datetime(6) -> timestamp
- failed_datetime — timestamp — type : datetime(6) -> timestamp
- completed_datetime — timestamp — type : datetime(6) -> timestamp
- user_id — uuid
- created_datetime — timestamp — NOT NULL — 새로 추가된 컬럼
- updated_datetime — timestamp — 새로 추가된 컬럼
withdrawal_point (postgreSQL) (withdrawal_point)
- id — bigint — NOT NULL
- withdrawal_id — bigint — name : withdrawals_id -> withdrawal_id
- point_id — bigint — name : pointsmodel_id -> point_id
- created_datetime — timestamp — NOT NULL — 새로 추가된 컬럼
- updated_datetime — timestamp — 새로 추가된 컬럼
withdrawal_user_bank_account (postgreSQL) (withdrawal_user_bank_account)
- id — bigint — NOT NULL
- bank_code — varchar(10) — NOT NULL
- bank_name — varchar(15) — NOT NULL
- c_bank_account_holder_name — varchar(100) — NOT NULL
- masked_bank_account_holder_name — varchar(50)
- c_bank_account_number — varchar(100) — NOT NULL
- masked_bank_account_number — varchar(50)
- c_social_security_number — varchar(100)
- created_datetime — timestamp — NOT NULL — type : datetime(6) -> timestamp
- updated_datetime — timestamp — type : datetime(6) -> timestamp
- is_removed — boolean — NOT NULL — type : tinyint(1) -> boolean
- removed_datetime — timestamp — type : datetime(6) -> timestamp
- withdrawal_id — bigint