erd cloud

Tables (58)

Account_Bank

  • account_bank_code — varchar(200)
  • account_bank_name — varchar(200)

Account_Deposit_Status

  • account_deposit_status_index — int(11) — Primary key — NOT NULL
  • account_deposit_status_mid — varchar(200)
  • account_deposit_status_user_index — int(11)
  • account_bank_code — varchar(200)
  • account_deposit_status_account — varchar(200)
  • account_deposit_status_date — varchar(200)
  • account_deposit_status — varchar(200)
  • account_deposit_insert_date — datetime
  • account_deposit_value — int(11)
  • account_deposit_tax — int(11)

Admin

  • admin_index — int(11) — Primary key — NOT NULL — 기본키
  • admin_type_index — int(11) — Foreign key → admin_Type.admin_type_index — NOT NULL — 관리자 타입 기본키
  • user_index — int(11) — Foreign key → User.user_index — NOT NULL
  • user_cm_index — INT(11) — Foreign key → User.user_cm_log_index — NOT NULL
  • admin_registration_date — date — 관리자 유저 등록일
  • admin_rank_name — int(11)

Advertisement

  • advertisement_index — int(11) — Primary key — NOT NULL
  • advertisement_photo — varchar(150)
  • advertisement_url — varchar(150)
  • user_index — int(11)
  • advertisement_create_time — datetime

Agent

  • agent_index — int(11) — Primary key — NOT NULL
  • user_index — int(11) — Foreign key → User.user_index — NOT NULL
  • user_cm_index — INT(11) — Foreign key → User.user_cm_log_index — NOT NULL
  • boss_user_index — int(11)
  • agent_rate — float
  • agent_cash_rate — float
  • agent_cm_rate — float
  • agent_distribution_flag — tinyint(1)
  • agent_registration_date — date

Authority_type

  • authority_type_index — int(11) — Primary key — NOT NULL
  • program_index — INT(11) — Foreign key → Program.program_index — NOT NULL
  • admin_type_index — int(11) — Foreign key → admin_Type.admin_type_index — NOT NULL — 관리자 타입 기본키
  • insert_authority — tinyint(1) — NOT NULL
  • delete_authority — tinyint(1) — NOT NULL
  • update_authority — tinyint(1) — NOT NULL

Banner

  • banner_index — int(11) — Primary key — NOT NULL
  • banner_photo — varchar(150)
  • user_index — int(11)
  • banner_create_time — datetime

Business_Area

  • business_area_index — int(11) — Primary key — NOT NULL
  • business_area_id — varchar(30)
  • business_area_pid — varchar(30)
  • business_area_name — varchar(30)
  • business_area_level — int(11)

Business_Grade

  • business_grade_index — int(11) — Primary key — NOT NULL
  • business_grade_name — varchar(30)
  • business_grade_rate — float
  • business_grade_level — int(11)

Business_Man

  • business_man_index — int(11) — Primary key — NOT NULL
  • user_index — int(11) — Foreign key → User.user_index — NOT NULL
  • business_grade_index (business_grade_index2) — int(11) — Foreign key → Business_Grade.business_grade_index — NOT NULL
  • business_area_index (business_area_index2) — int(11) — Foreign key → Business_Area.business_area_index — NOT NULL
  • user_cm_index — INT(11) — Foreign key → User.user_cm_log_index — NOT NULL
  • boss_user_index — int(11)
  • business_man_distribution_flag — tinyint(1)
  • business_man_registration_date — date
  • business_man_create_date — datetime

Cms_Access_Log

  • cms_access_log_index — INT(11) — Primary key — NOT NULL
  • cms_access_user_index — INT(11) — NOT NULL
  • cms_access_user_value — VARCHAR(100)
  • cms_access_user_ip — VARCHAR(100)
  • cms_access_user_time — DATETIME

Coupon

  • coupon_index — INT(11) — Primary key — NOT NULL
  • coupon_issuance_status_index — INT(11) — Foreign key → Coupon_issuance_status.coupon_issuance_status_index — NOT NULL
  • coupon_provided_status_index — INT(11) — Foreign key → Coupon_provided_status.coupon_provided_status_index — NOT NULL
  • issuance_user_index — INT(11)
  • provided_user_index — INT(11)
  • nonmembers_number — INT(11)
  • coupon_price — INT(11)
  • coupon_limit — INT(11)
  • coupon_name — VARCHAR(100)
  • coupon_issuance_time — DATETIME
  • coupon_provided_time — DATETIME
  • coupon_limit_time — DATETIME
  • coupon_condition — VARCHAR(500)

Coupon_issuance_status

  • coupon_issuance_status_index — INT(11) — Primary key — NOT NULL
  • coupon_issuance_status — VARCHAR(50)

Coupon_provided_status

  • coupon_provided_status_index — INT(11) — Primary key — NOT NULL
  • coupon_provided_status — VARCHAR(50) — NOT NULL

Distribution_Rate

  • distribution_rate_index — INT(11) — Primary key — NOT NULL
  • user_role_index — INT(11)
  • distribution_cm_rate — FLOAT
  • distribution_cash_rate — FLOAT

Event_Attend

  • event_attend_index — INT(11) — Primary key — NOT NULL
  • event_master_index — INT(11) — Foreign key → Event_Master.event_master_index — NOT NULL
  • event_attend_user — INT(11)

Event_Detail

  • event_detail_index — INT(11) — Primary key — NOT NULL
  • event_master_index — INT(11) — Foreign key → Event_Master.event_master_index — NOT NULL
  • event_coupon_index — INT(11)

Event_Gift

  • event_gift_index — INT(11) — Primary key — NOT NULL
  • event_gift_name — VARCHAR(50) — NOT NULL
  • event_gift_value — INT(11) — NOT NULL
  • event_gift_date — DATETIME
  • event_gift_store_name — TEXT

Event_Gift_Flag

  • user_index — INT(11) — Primary key — NOT NULL
  • gift_time — DATETIME
  • event_gift_name — VARCHAR(50)

Event_Gift_Result

  • gift_user_index — INT(11)
  • store_user_index — INT(11)
  • join_time — DATETIME
  • event_gift_value — INT(11)

Event_Master

  • event_master_index — INT(11) — Primary key — NOT NULL
  • evnet_master_name — VARCHAR(500) — NOT NULL
  • event_master_contidion — VARCHAR(500) — NOT NULL
  • event_master_limit — INT(11) — NOT NULL
  • event_master_count — INT(11)
  • event_master_userIndex — INT(11)
  • event_master_num — INT(11)

Menu

  • menu_index — INT(11) — Primary key — NOT NULL
  • manu_name — VARCHAR(200) — NOT NULL
  • menu_value — VARCHAR(200) — NOT NULL
  • menu_order — INT(11)

Notice

  • notice_index — INT(11) — Primary key — NOT NULL
  • user_index — int(11) — Foreign key → User.user_index — NOT NULL
  • user_cm_index — INT(11) — Foreign key → User.user_cm_log_index — NOT NULL
  • notice_title — VARCHAR(150)
  • notice_desc — TEXT
  • notice_create_time — DATETIME

Premium_Code

  • code_id — INT(11) — Primary key — NOT NULL
  • card_num — VARCHAR(50) — NOT NULL
  • used — CHAR(1) — NOT NULL
  • user_index — INT(11)
  • used_date — DATETIME

Program

  • program_index — INT(11) — Primary key — NOT NULL
  • menu_index — INT(11) — Foreign key → Menu.menu_index — NOT NULL
  • program_name — VARCHAR(200)
  • program_url — VARCHAR(200)
  • program_value — VARCHAR(200)
  • program_order — INT(11)

Qna

  • qna_index — INT(11) — Primary key — NOT NULL
  • question_user_index — INT(11)
  • question_title — VARCHAR(150)
  • question_desc — TEXT
  • answer_user_index — INT(11)
  • answer_title — VARCHAR(150)
  • answer_desc — TEXT
  • qna_create_time — DATETIME
  • answer_create_time — DATETIME

Setting

  • setting_index — INT(11) — Primary key — NOT NULL — 설정 기본키
  • setting_name — VARCHAR(50) — 설정 이름' COLLATE 'utf8mb4_general_ci
  • setting_value — VARCHAR(50) — 설정 값' COLLATE 'utf8mb4_general_ci

Smartro_Card_Fail_Code

  • fail_code — INT(11) — Primary key — NOT NULL
  • fail_msg — VARCHAR(100)

Store

  • store_index — INT(11) — Primary key — NOT NULL
  • user_index — int(11) — Foreign key → User.user_index — NOT NULL
  • user_cm_index — INT(11) — Foreign key → User.user_cm_log_index — NOT NULL
  • business_man_user_index — INT(11)
  • store_registration_num — VARCHAR(90)
  • store_type_taxation — VARCHAR(90)
  • store_corporate_name — VARCHAR(90)
  • store_boss_name — VARCHAR(90)
  • store_business_license_photo — VARCHAR(300)
  • store_name — varchar(90)
  • store_phone — VARCHAR(90)
  • store_site — VARCHAR(150)
  • store_zone_code — VARCHAR(30)
  • store_address — VARCHAR(90)
  • store_detail_address — VARCHAR(90)
  • store_sign_photo — VARCHAR(300)
  • store_pront_photo — VARCHAR(300)
  • store_transaction_status — TINYINT(1)
  • store_request_status_index — INT(11)
  • store_qr_code — VARCHAR(90)
  • store_marketing_agree — VARCHAR(30)
  • store_aed_agree — VARCHAR(30)
  • store_low_agree — VARCHAR(30)
  • store_pos1 — TEXT
  • store_pos2 — TEXT
  • store_registration_date — DATETIME
  • store_create_date — DATETIME
  • store_cancel_memo — VARCHAR(300)
  • store_holiday_status — VARCHAR(50)
  • store_regular_closing_interval — VARCHAR(50)
  • store_regular_closing_week — VARCHAR(50)
  • store_temporary_closing_date — VARCHAR(300)
  • store_temporary_closing_comment — VARCHAR(300)
  • store_memo — TEXT
  • store_save_value — INT(11)
  • store_customer_flag — INT(2)
  • store_limit — INT(11)
  • franchise_fee — INT(11)

Store_Business_Hours

  • store_business_hours_index — INT(11) — Primary key — NOT NULL
  • store_user_index — INT(11)
  • store_start_business_hour — VARCHAR(100)
  • store_end_business_hour — VARCHAR(100)
  • store_rest_status — VARCHAR(30)
  • store_rest_start_hour — VARCHAR(100)
  • store_rest_end_hour — VARCHAR(100)
  • store_business_date — VARCHAR(100)

Store_Category

  • store_category_index — INT(11) — Primary key — NOT NULL
  • store_category_name — VARCHAR(30)

Store_Customer

  • store_store_user_index — VARCHAR(50) — Primary key — NOT NULL
  • store_customer_user_index — VARCHAR(50) — Primary key — NOT NULL
  • store_customer_status — VARCHAR(6)
  • store_customer_insert_date — DATETIME

Store_Image

  • store_image_index — INT(11) — Primary key — NOT NULL
  • store_user_index — INT(11) — NOT NULL
  • store_image — VARCHAR(200) — NOT NULL
  • store_main_image_status — VARCHAR(50)

Store_Post_Detail

  • store_post_detail_index — INT(11) — Primary key — NOT NULL
  • store_post_master_index — INT(11)
  • store_post_detail_name — VARCHAR(100)
  • store_post_detail_number — VARCHAR(100)

Store_Post_Master

  • store_post_master_index — INT(11) — Primary key — NOT NULL
  • store_post_master_name — VARCHAR(100)
  • store_post_master_number — VARCHAR(100)

Store_Request_Status

  • store_request_status_index — INT(11) — Primary key — NOT NULL
  • store_request_status_name — VARCHAR(30)

Store_Subscription_Fee

  • store_subscription_fee_index — INT(11) — Primary key — NOT NULL
  • store_subscription_fee_transaction_name — VARCHAR(200)
  • business_man_user_index — INT(11) — NOT NULL
  • store_subscription_fee_time — DATETIME — NOT NULL
  • store_user_index — INT(11)
  • store_subscription_fee_payment_method — VARCHAR(200)
  • store_subscription_fee_commission_check — VARCHAR(200)
  • store_subscription_fee_value — INT(11)

Suggestion_User

  • suggestion_user_index — INT(11) — Primary key — NOT NULL
  • recommendation_user_index — INT(11) — Primary key — NOT NULL
  • join_date — DATETIME — NOT NULL

Temporary_Regular_Detail

  • temporary_store_detail_index — INT(11) — Primary key — NOT NULL
  • user_index — INT(11) — NOT NULL — 추천인
  • original_cash_value — INT(11) — NOT NULL — 지급액
  • tax — VARCHAR(8) — NOT NULL — 세금' COLLATE 'utf8mb4_general_ci
  • account — VARCHAR(50) — 계좌번호' COLLATE 'utf8mb4_general_ci
  • temporary_regular_cash_value — DOUBLE — NOT NULL — 실제 지급액
  • payment_status — VARCHAR(50) — NOT NULL — 지급여부' COLLATE 'utf8mb4_general_ci
  • description — VARCHAR(50) — NOT NULL
  • temporary_regular_master_index — INT(11) — NOT NULL — 임시 마스터 테이블 참조키값

Temporary_Regular_Master

  • temporary_store_master_index — INT(11) — Primary key — NOT NULL
  • store_user_index — INT(11)
  • temporary_store_master_transaction_name — VARCHAR(200) — NOT NULL
  • temporary_store_master_charge_time — DATETIME
  • temporary_store_master_distribution_time — DATETIME
  • temporary_store_master_distribution_status — VARCHAR(30)
  • temporary_store_cm_value — INT(11)
  • temporary_store_cash_value — INT(11)
  • temporary_store_fee_value — INT(11)

Temporary_Regular_Premium

  • premium_index — INT(11) — Primary key — NOT NULL
  • user_index — INT(11)
  • premium_charge_time — DATETIME
  • temporary_regular_master_index — INT(11)
  • card_num — VARCHAR(50)

Temporary_Store_Master

  • temporary_store_master_index — INT(11) — Primary key — NOT NULL
  • store_user_index — INT(11)
  • temporary_store_master_transaction_name — VARCHAR(200) — NOT NULL
  • temporary_store_master_charge_time — DATETIME
  • temporary_store_master_distribution_time — DATETIME
  • temporary_store_master_distribution_status — VARCHAR(30)
  • temporary_store_cm_value — INT(11)
  • temporary_store_cash_value — INT(11)
  • temporary_store_fee_value — INT(11)
  • INDEX — `idx_tsm_master_index`
  • INDEX — `idx_tsm_charge_time`
  • INDEX — `idx_tsm_transaction_name`

Update_User_Log

  • update_user_log_index — INT(11) — Primary key — NOT NULL
  • update_user_index — INT(11)
  • inflict_user_index — INT(11)
  • update_before_data — TEXT
  • update_after_data — TEXT
  • update_user_log_update_time — DATETIME
  • update_data_value — TEXT

User

  • user_index — int(11) — Primary key — NOT NULL
  • user_bank_index — INT(11) — Foreign key → User_Bank.user_bank_index — NOT NULL
  • user_gender_index — INT(11) — Foreign key → User_Gender.user_gender_index — NOT NULL
  • user_role_index — INT(11) — Foreign key → User_Role.user_role_index — NOT NULL
  • user_cm_log_index (user_cm_index) — INT(11) — Foreign key → User_Cm.user_cm_index — NOT NULL
  • user_id — varchar(90)
  • user_pw — varchar(90)
  • user_name — varchar(90)
  • user_email — varchar(90)
  • user_phone — varchar(90)
  • user_birthday — date
  • user_bank_number — varchar(90)
  • user_bank_holder — varchar(90)
  • user_zone_code — varchar(90)
  • user_address — varchar(90)
  • user_detail_address — varchar(90)
  • user_profile — longblob
  • user_qr_code — varchar(200)
  • user_amount — int(11)
  • user_transaction_status — varchar(50)
  • user_login_status — varchar(90)
  • store_main_user_index — int(11)
  • user_key — varchar(90)
  • user_coupon_index — longtext
  • coupon_amount — int(11)
  • user_index_insert — int(11)
  • user_provide — varchar(50)
  • user_marketing_checked — varchar(50)
  • user_advertisement_checked — varchar(50)
  • user_position_checked — varchar(50)
  • user_login_status2 — int(11)
  • user_jumin — varchar(50)
  • signup_path — varchar(20)
  • user_cm_log_index — int(11)

User_Bank

  • user_bank_index — INT(11) — Primary key — NOT NULL
  • user_bank_name — VARCHAR(6)

User_Cm

  • user_cm_index — INT(11) — Primary key — NOT NULL
  • user_cm_deposit — INT(11)
  • user_cm_withdrawal — INT(11)
  • user_cash_deposit — INT(11)
  • user_cash_withdrawal — INT(11)
  • user_cmp_deposit — INT(11)
  • user_cmp_withdrawal — INT(11)
  • user_cmp_init — INT(11)
  • user_cm_pincode — VARCHAR(6)

User_Cm_Log

  • user_cm_log_index — INT(11) — Primary key — NOT NULL
  • user_cm_log_payment_index — INT(11)
  • user_cmp_log_payment_index — INT(11)
  • user_cm_log_transaction_type_index — INT(11)
  • user_cm_log_value_type_index — INT(11)
  • user_index_event_trigger — INT(11)
  • user_index_event_party — INT(11)
  • user_cm_log_value — INT(11)
  • user_cm_log_reason — VARCHAR(90)
  • user_cm_log_create_time — DATETIME
  • user_cm_log_transaction_cancel — VARCHAR(30)
  • user_coupon_value — INT(11)

User_Cm_Log_Payment

  • user_cm_log_payment_index — INT(11) — Primary key — NOT NULL
  • user_cm_log_payment_name — VARCHAR(30)

User_Cm_Log_Transaction_Type

  • user_cm_log_transaction_type_index — INT(11) — Primary key — NOT NULL
  • user_cm_log_transaction_type_name — VARCHAR(30)

User_Cm_Log_Value_Type

  • user_cm_log_value_type_index — INT(11) — Primary key — NOT NULL
  • user_cm_log_value_type_name — VARCHAR(30)

User_Cmp_Log_Payment

  • user_cmp_log_payment_index — INT(11) — Primary key — NOT NULL
  • user_cmp_log_payment_name — VARCHAR(30)

User_Gender

  • user_gender_index — INT(11) — Primary key — NOT NULL
  • user_gender_name — VARCHAR(6)

User_Regular

  • user_regular_index — INT(11) — Primary key — NOT NULL
  • user_role_index — INT(11) — Foreign key → User_Role.user_role_index — NOT NULL
  • cm_rate — INT(3)
  • cash_begin — INT(11)
  • cash_end — INT(11)

User_Role

  • user_role_index — INT(11) — Primary key — NOT NULL
  • user_role_eng_nm — VARCHAR(60)
  • user_role_kor_nm — VARCHAR(60)

Withdrawal_Detail

  • withdrawal_detail_index — INT(11) — Primary key — NOT NULL
  • withdrawal_master_index — INT(11) — Foreign key → Withdrawal_Master.withdrawal_master_index — NOT NULL
  • temporary_store_master_index — INT(11) — NOT NULL

Withdrawal_Master

  • withdrawal_master_index — INT(11) — Primary key — NOT NULL
  • withdrawal_master_name — VARCHAR(200) — NOT NULL
  • withdrawal_master_status — VARCHAR(200) — NOT NULL

admin_Type

  • admin_type_index — int(11) — Primary key — NOT NULL — 관리자 타입 기본키
  • admin_type_name — varchar(90) — 관리자 타입 이름
  • admin_type_order — int(11)

regular_payment

  • id — INT(11) — Primary key — NOT NULL
  • user_index — INT(11) — NOT NULL
  • resultCd — VARCHAR(10)
  • resultMsg — VARCHAR(100)
  • advanceMsg — VARCHAR(100)
  • create_time — DATETIME
  • authCd — VARCHAR(20)
  • cardId — VARCHAR(50)
  • installment — INT(11)
  • bin — VARCHAR(10)
  • last4 — VARCHAR(10)
  • issuer — VARCHAR(100)
  • cardType — VARCHAR(20)
  • acquirer — VARCHAR(100)
  • webhookUrl — VARCHAR(255)
  • trxId — VARCHAR(30)
  • trxType — VARCHAR(20)
  • tmnId — VARCHAR(20)
  • trackId — VARCHAR(50)
  • amount — INT(11)
  • udf1 — VARCHAR(255)
  • udf2 — VARCHAR(255)