Title

Tables (8)

en_rexceptionschedule

  • datetime — datetime — Primary key — NOT NULL
  • merchant_id — mediumint(5) — Primary key — NOT NULL
  • name — varchar(255)

en_rschedule

  • merchant_id — mediumint(5) — Primary key — NOT NULL
  • schedule_id — mediumint(4) — Primary key — NOT NULL
  • name — varchar(100)

en_rscheduledetail

  • merchant_id — mediumint(5) — Primary key — NOT NULL
  • order_time — datetime — Primary key — NOT NULL
  • schedule_id — mediumint(4) — Primary key — NOT NULL
  • name — varchar(255)

rdeliverytiming

  • merchant_id — mediumint(5) — Primary key — NOT NULL
  • timing_id — mediumint(5) — Primary key — NOT NULL
  • start_time — datetime
  • end_time — datetime
  • tag — text

rexceptionschedule

  • datetime — datetime — Primary key — NOT NULL
  • merchant_id — mediumint(5) — Primary key — NOT NULL
  • schedule_id — mediumint(4)

rroutineschedule

  • day_of_week — tinyint(1) — Primary key — NOT NULL
  • merchant_id — mediumint(5) — Primary key — NOT NULL
  • schedule_id — mediumint(4)

rschedule

  • merchant_id — mediumint(5) — Primary key — NOT NULL
  • schedule_id — mediumint(4) — Primary key — NOT NULL
  • delete_not — tinyint(1)
  • insert_datetime — datetime

rscheduledetail

  • merchant_id — mediumint(5) — Primary key — NOT NULL
  • order_time — datetime — Primary key — NOT NULL
  • schedule_id — mediumint(4) — Primary key — NOT NULL
  • adjust_day — tinyint(2)
  • adjust_time_type — tinyint(1)
  • adjust_time_hour — tinyint(2)
  • adjust_time_min — tinyint(2)
  • timing_id — mediumint(5)