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