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)