ERP 연습
테이블 (28)
Account_Bank
- admin_type_index — int(11) — 기본 키 — NOT NULL — 관리자 타입 참조키
- account_bank_code — varchar(200)
- account_bank_name — varchar(200) — 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)
- user_index — int(11) — 유저 테이블 참조키
- admin_registration_date — date — 관리자 유저 등록일
- admin_rank_name — varchar(300)
- admin_type_name — varchar(90) — 관리자 타입 이름
- admin_type_order — int(11)
- advertisement_photo — varchar(150)
- advertisement_url — varchar(150)
- user_index — int(11)
- advertisement_create_time — datetime
- user_index — int(11)
- 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
- program_index — int(11) — NOT NULL
- admin_type_index — int(11) — NOT NULL
- insert_authority — tinyint(1) — NOT NULL
- delete_authority — tinyint(1) — NOT NULL
- update_authority — tinyint(1) — NOT NULL
- banner_photo — varchar(150)
- user_index — int(11)
- banner_create_time — datetime
- business_area_id — varchar(30)
- business_area_pid — varchar(30)
- business_area_name — varchar(30)
- business_area_level — int(11)
- business_grade_name — varchar(30)
- business_grade_rate — float
- business_grade_level — int(11)
- user_index — int(11)
- boss_user_index — int(11)
- business_grade_index — int(11)
- business_area_index — int(11)
- business_man_distribution_flag — tinyint(1)
- business_man_registration_date — date
- business_man_create_date — datetime
- user_index — int(11)
- boss_user_index — int(11)
- business_grade_index — int(11)
- business_area_index — int(11)
- business_man_distribution_flag — tinyint(1)
- business_man_registration_date — date
- business_man_create_date — datetime
- cms_access_user_index — int(11) — NOT NULL
- cms_access_user_value — varchar(100)
- cms_access_user_ip — varchar(100)
- … +1
Coupon
- coupon_index — int(11) — 기본 키 — 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_issuance_status_index — int(11)
- coupon_name — varchar(100)
- coupon_issuance_time — datetime
- coupon_provided_status_index — int(11)
- coupon_provided_time — datetime
- coupon_limit_time — datetime
- coupon_condition — varchar(500)
- coupon_issuance_status — varchar(50)
Coupon_provided_status
- coupon_provided_status_index — int(11) — 기본 키 — NOT NULL
- coupon_provided_status — varchar(50) — NOT NULL
Distribution_Rate
- distribution_rate_index — int(11) — 기본 키 — NOT NULL
- user_role_index — int(11)
- distribution_cm_rate — float
- distribution_cash_rate — float
- event_master_index — int(11)
- event_attend_user — int(11)
Event_Detail
- event_detail_index — int(11) — 기본 키 — NOT NULL
- event_master_index — int(11)
- event_coupon_index — int(11)
Event_Gift
- event_gift_index — int(11) — 기본 키 — 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) — 기본 키 — 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) — 기본 키 — 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) — 기본 키 — NOT NULL
- manu_name — varchar(200) — NOT NULL
- menu_value — varchar(200) — NOT NULL
- menu_order — int(11)
- user_index — int(11)
- notice_title — varchar(150)
- notice_desc — text
- notice_create_time — datetime
- card_num — varchar(50) — NOT NULL
- used — char(1) — NOT NULL
- user_index — int(11)
- used_date — datetime
Program
- program_index — int(11) — 기본 키 — NOT NULL
- program_name — varchar(200)
- program_url — varchar(200)
- menu_index — int(11)
- program_value — varchar(200)
- program_order — int(11)
- 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
- 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)
Setting
- setting_index — int(11) — 기본 키 — NOT NULL — 설정 기본키
- setting_name — varchar(50) — 설정 이름
- setting_value — varchar(50) — 설정 값
Smartro_Card_Fail_Code
- fail_code — int(11) — 기본 키 — NOT NULL
- fail_msg — varchar(100)
Store
- store_index — int(11) — 기본 키 — NOT NULL
- store_customer_user_index — varchar(50) — 기본 키 — NOT NULL
- user_index — int(11)
- 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_category_index — int(11)
- 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_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_name — varchar(30)
- store_customer_status — varchar(6)
- store_customer_insert_date — datetime
- store_user_index — int(11) — NOT NULL
- store_image — varchar(200) — NOT NULL
- store_main_image_status — varchar(50)
- 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) — 기본 키 — NOT NULL
- store_post_master_name — varchar(100)
- store_post_master_number — varchar(100)
Store_Request_Status
- store_request_status_index — int(11) — 기본 키 — NOT NULL
- store_request_status_name — varchar(30)
- 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) — 기본 키 — NOT NULL
- recommendation_user_index — int(11) — 기본 키 — NOT NULL
- join_date — datetime — NOT NULL
- user_index — int(11) — NOT NULL — 추천인
- original_cash_value — int(11) — NOT NULL — 지급액
- tax — varchar(8) — NOT NULL — 세금
- account — varchar(50) — 계좌번호
- temporary_regular_cash_value — double — NOT NULL — 실제 지급액
- payment_status — varchar(50) — NOT NULL — 지급여부
- description — varchar(50) — NOT NULL
- temporary_regular_master_index — int(11) — 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) — 기본 키 — NOT NULL
- user_index — int(11)
- premium_charge_time — datetime
- temporary_regular_master_index — int(11)
- card_num — varchar(50)
Temporary_Store_Detail
- temporary_store_detail_index — int(11) — 기본 키 — NOT NULL
- temporary_store_master_index — int(11) — 기본 키 — NOT NULL — 임시 통장 마스터 테이블 참조키값
- user_index — int(11) — 기본 키 — NOT NULL — 지급 받을 관리자,사업자 유저 index (하지만 관리자는 분배 전에 이미 지급이 됨)
- business_grade_name — varchar(100) — NOT NULL — 해당 사업자의 등급 이름
- business_area_name — varchar(100) — NOT NULL — 해당 사업자의 지역 이름
- temporary_store_cm_value — double — NOT NULL — 분배 받을 양
- temporary_store_cash_value — double — 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)
- 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_id — varchar(90)
- user_pw — varchar(90)
- user_name — varchar(90)
- user_email — varchar(90)
- user_phone — varchar(90)
- user_birthday — date
- user_gender_index — int(11)
- user_role_index — int(11) — NOT NULL
- user_bank_index — int(11)
- 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_create_time — datetime
- user_update_time — datetime
- user_index_modifier — int(11)
- user_qr_code — varchar(200)
- user_amount — int(11)
- user_transaction_status — varchar(50)
- user_login_status — varchar(100)
- user_cm_log_index — int(11)
- store_main_user_index — int(11)
- user_key — varchar(255)
- 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_upgrade — varchar(50)
- user_jumin — varchar(50)
- signup_path — varchar(20)
- user_vip — varchar(20)
- user_id — varchar(90)
- user_pw — varchar(90)
- … +34
User_Cm
- user_cm_index — int(11) — 기본 키 — 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_cmp_log_payment_name — varchar(30)
User_Cm_Backup
- user_cm_index — int(11) — 기본 키 — 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_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) — 기본 키 — NOT NULL
- user_cm_log_payment_name — varchar(30)
User_Cm_Log_Transaction_Type
- user_cm_log_transaction_type_index — int(11) — 기본 키 — NOT NULL
- user_cm_log_transaction_type_name — varchar(30)
User_Cm_Log_Value_Type
- user_cm_log_value_type_index — int(11) — 기본 키 — NOT NULL
- user_cm_log_value_type_name — varchar(30)
User_Gender
- user_gender_index — int(11) — 기본 키 — NOT NULL
- user_gender_name — varchar(6)
User_Role
- user_role_index — int(11) — 기본 키 — NOT NULL
- user_role_eng_nm — varchar(60)
- user_role_kor_nm — varchar(60)
User_old
- user_index — int(11) — 기본 키 — 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_gender_index — int(11)
- user_role_index — int(11) — NOT NULL
- user_bank_index — int(11)
- 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_create_time — datetime
- user_update_time — datetime
- user_index_modifier — int(11)
- user_qr_code — varchar(200)
- user_amount — int(11)
- user_transaction_status — varchar(50)
- user_login_status — varchar(100)
- user_cm_log_index — int(11)
- store_main_user_index — int(11)
- user_key — varchar(255)
- 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_upgrade — varchar(50)
- user_role_index — int(11)
- cm_rate — int(3)
- cash_begin — int(11)
- cash_end — int(11)
Withdrawal_Detail
- withdrawal_detail_index — int(11) — 기본 키 — NOT NULL
- withdrawal_master_index — int(11) — 기본 키 — NOT NULL
- temporary_store_master_index — int(11) — NOT NULL
- withdrawal_master_name — varchar(200) — NOT NULL
- withdrawal_master_status — varchar(200) — NOT NULL