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