2023年7月27日发(作者：)

数据库表结构设计数据库:ads数据库模型类基类:BaseModelclass BaseModel(): """模型类基类""" create_time = meField(auto_now_add=True, verbose_name="添加时间") class Meta: # 声明为抽象基类后， BaseModel不会单独创建⼀个表 # 只有在被继承的⼦类中⾃动添加BaseModel中的字段 abstract = True # 说明是抽象模型类, ⽤于继承使⽤,数据库迁移时不会创建BaseModel的表⽤户基本信息表:User(BaseModel)id:主键,⾃增长,django模型类默认⾃动添加account:登录账户,必填,唯⼀,account = eld(max_length=20, unique=True, verbose_name='登录账户')password:登录密码,⾮必填,默认:888888,password = eld(max_length=20, default='888888', verbose_name='登录密码')username:⽤户名称,⾮必填,username = eld(max_length=20,null=True,verbose_name='⽤户名称')is_delete:逻辑删除,默认0,is_delete = nField(default=False, verbose_name='逻辑删除')⾓⾊表:Roleid:name:媒体运营,⼴告运营,活动运营,财务,技术,必填desc:⾓⾊描述,⾮必填⽤户所属⾓⾊表:UserRoles,⼀个⽤户可以同时有多重⾓⾊id:user_id:外键role_id:外键⾓⾊权限表:RolePermissionsid:role_id:外键permission_id:外键权限表:Permissionid:name:列表,操作,添加计划,⼴告主客户,媒体商客户⼴告主客户表:AdOwner(BaseModel)id:contact_phone:联系⼈⼿机号,可作登录账号,唯⼀,必填password:登录密码,必填contact_name:联系⼈姓名,⾮必填email:邮箱,必填ad_owner_identity_id:外键agent_id:外键,⼦账户时,所属代理商idcompany:公司名称,必填company_address:公司地址,⾮必填business_license_code:营业执照号,⾮必填business_license_img:营业执照照⽚,⾮必填ad_operator:⼴告运营⼈员,必填seller:销售⼈员,必填total_amount:累计⾦额,初始为0available_balance:可⽤余额,初始为0status:审核状态,0:审核中,1:审核通过,-1:审核不通过⼴告主⾝份表:AdOwnerIdentityid:name:直客,代理商,⼦账户代理商列表:Agentid:name:媒体商表:MediaDealer(BaseModel),类似于阿⾥巴巴,旗下⽀付宝,淘宝⽹,⼝碑,就是媒体id:contact_phone:联系⼈⼿机号,可做登录账号,唯⼀,必填password:登录密码,必填contact_name:联系⼈姓名,⾮必填email:邮箱,必填company:公司名称,必填company_address:公司地址,⾮必填business_license_code:营业执照号,⾮必填business_license_img:营业执照照⽚,⾮必填media_operator:媒体运营⼈员,必填medium:媒介,必填total_amount:累计⾦额,初始为0cash_withdrawal_balance:可提现余额,初始为0remarks:备注,⾮必填status:审核状态,0:审核中,1:审核通过,-1:审核不通过媒体表:Media(BaseModel)id:media_dealer_id:媒体商id,外键name:媒体名称,必填media_operator:媒体运营⼈员,必填medium:媒介,必填status:审核状态,0:审核中,1:审核通过,-1:审核不通过--------------------------------------------------------以上问题不⼤⼴告位表:AdSpace(BaseModel)id:media_id:媒体id,例:⽀付宝,外键ad_space_name:⼴告位名称,banner,icon,信息流,必填appkey:默认为'',⾮必填size:⼴告位⼤⼩,⾮必填is_gif:是否⽀持gif,⾮必填status:审核状态,0:审核中,1:审核通过,-1:审核不通过⼴告位活动表:AdSpaceActivitysid:ad_space_id:⼴告位id,外键activity_id:活动id,外键is_active:是否选择⼴告位选择:AdSpaceChoices,即屏蔽策略,选择了哪些⾏业,地域,投放形式,去重id:ad_space_id:⼴告位id,外键industry_id:⾏业id,外键,唯⼀,默认为0area_id:地域id,外键,唯⼀,默认为0delivery_form_id:投放形式id,外键,唯⼀,默认为0⾏业表:Industryid:name:股票,彩票,游戏,⽹赚,外汇,药品,3C数码,港澳台地域表:Area,⾃关联,中国,华北地区,内蒙古,阿拉善盟id:name:parent_id:外键,⾃关联投放形式表:DeliveryFormid:name:表单填写,注册,下载,加粉活动模板表:ActivityTemplateid:type:活动类型,⼤转盘,砸⾦蛋,答题,套⽜image:模板图⽚活动表:Activityid:activity_template_id:活动模板id,可获取活动类型banner:活动主题banner图⽚title:活动标题,答题赢现⾦start_time:开始时间end_time:结束时间count:活动次数sort_number:活动排序,曝光排序,1,可修改activity_operator:活动运营⼈员is_active:开启状态is_delete:逻辑删除url:活动链接--------------------------------------------------------------2018年10⽉25⽇⼴告计划表:Plan(BaseModel)id:name:计划名称ad_owner_id:⼴告主idunit_price:计费单价,⼿动输⼊daily_budget:⽇预算,500,不限⽇预算,默认不限制exposure:曝光,500billing_click:计费点击,500conversion_pv:转化PVclick_rate:点击率,12%today_consume:今⽇消耗,100total_consume:总消耗,1000start_date:投放开始⽇期end_date:投放结束⽇期start_time:投放开始时间end_time:投放结束时间exposure_sort:曝光排序,1,默认按添加时间排序plan_status:状态,⽣效中,暂停,未投放(⾮投放⽇期),未投放(⽇预算不⾜)is_active:开启关闭delivery_form_id:投放形式id,外键industry_id:⼴告⾏业id,外键billing_type:计费类型operating_system:ios,android,其他,默认全部url:投放链接desc:⼴告描述button_name:按钮名称banner:⼴告banner图ad_details:⼴告详情important_statement:重要声明put_area:投放地域,全部地域,部分地域media_setting:媒体设置,全部,定投,屏蔽计划选择表:PlanChoice,即屏蔽,地域选择,⼴告位选择id:plan_id:⼴告位id,外键area_id:地域id,外键,唯⼀,默认0ad_space_id:⼴告位id,外键,唯⼀,默认0⼴告数据表:AdDataid:date:⽇期plan_id:计划idad_owner_id:⼴告主id,外键ad_space_id:⼴告位id,外键click_uv:点击UVactual_pv:落地页访问PVctr:CTR,40%cvr:CVR,50%媒体数据表:MediaDataid:date:⽇期ad_space_id:⼴告位id,外键media_id:媒体id,外键entrance_exposure:⼊⼝曝光entrance_click:⼊⼝点击access_pv:访问PVaccess_uv:访问UVparticipate_uv:参与UVparticipate_pv:参与PVad_exposure:⼴告曝光billing_click:计费点击income:收益active_uv:活动UVseparate:分成voucher_success_rate:发券成功率*分成表:Separateid:ad_space_id:⼴告位id,外键activity_uv:活动uvseparate:分成活动数据表:ActivityDataid:date:⽇期activity_id:活动id,外键access_pv:访问PVaccess_uv:访问UVparticipate_uv:参与UVparticipate_pv:参与PVad_exposure:⼴告曝光ad_click:⼴告点击participation_rate:参与率complex_participation:复参every_uv_coupon:每UV发券every_uv_click:每UV券点击voucher_success_rate:发券成功率⼴告主充值表:Rechargeid:ad_owner_id:⼴告主id,外键before_recharge_balance:充值前余额,只读recharge_amount:充值⾦额after_recharge_balance:充值后余额,只读rebate_amount:返点⾦额payment_voucher:打款凭证,图⽚invoice_type:发票类型,不开票,普通发票,专发票recharge_time:发起充值时间status:审核状态company:公司名称address:公司地址taxpayer_identification_number:纳税⼈识别号bank:开户银⾏bank_account:银⾏账号notes:备注媒体商结算表:Settlementid:media_dealer_id:媒体商id,外键settlement_type:结算类型,提现,预付before_settlement_balance:结算前余额settlement_amount:结算⾦额tax_deduction_amount:扣税⾦额after_tax_deduction_amount:扣税后⾦额after_settlement_balance:结算后余额invoice_type:发票类型,不开票,普通发票,专发票upload_invoice:上传发票,图⽚查看打款账户pay_name:打款户名pay_account:打款账号pay_bank:⽀⾏信息cash_withdrawal_time:提现时间status:结算状态,已打款,未打款notes:备注