mail

Tables (4)

daily_mail (Untitled2)

  • bigint (id) — Primary key — NOT NULL
  • bigint (mail_template_id) — Foreign key → mail_template.bigint — NOT NULL
  • json (DayOfWeeks)
  • time (start_time)
  • time (during_time)
  • time (standard_time)
  • bool (is_random_start_time)

disposable_mail (CopyOfUntitled2)

  • bigint (id) — Primary key — NOT NULL
  • bigint (mail_template_id) — Foreign key → mail_template.bigint — NOT NULL
  • datetime (start_date_time)
  • datetime (end_date_time)

mail_receive_state (Untitled3)

  • bigint (id) — Primary key — NOT NULL
  • bigint (mail_template_id) — Foreign key → mail_template.bigint — NOT NULL
  • int (channel_number)
  • varchar (uid)
  • datetime (last_update_time)

mail_template (Untitled)

  • bigint (id) — Primary key — NOT NULL
  • varchar (description)
  • varchar (content)
  • int (level_limit)
  • bigint (sub_mail_id)
  • int (mail_category)
  • int (goods_type)
  • int (reward_amoun)