RSVP MQ

Tables (5)

assets_zip

  • id — INT — Primary key — NOT NULL
  • product_id (prd_id) — INT — Foreign key → product.id — NOT NULL
  • HI/LOW (resolution) — VARCHAR(10)
  • start wm (start) — INT
  • end wm (end) — INT
  • req_cnt — INT
  • status — ENUM('P', 'C', 'F')
  • create_ts — TIMESTAMP
  • request_ts — TIMESTAMP

product

  • id — INT — Primary key — NOT NULL
  • site_id — INT — Foreign key → sites.id — NOT NULL
  • Product Code (prd_code) — VERCHAR(10)
  • Product Name (prd_name) — VERCHAR(50)
  • In use now (is_valid) — ENUM('Y', 'N')
  • List Order (product_ord) — INT

sites

  • id — INT — Primary key — NOT NULL
  • Field

wm_zip

  • id — INT — Primary key — NOT NULL
  • zip_id — INT — Foreign key → assets_zip.id — NOT NULL
  • wm_seq — INT
  • status — ENUM('Y', 'N', 'F')

zip_request_log

  • id — INT — Primary key — NOT NULL
  • zip_id — INT — Foreign key → assets_zip.id — NOT NULL
  • request time (request_ts) — TIMESTAMP
  • finish time (finish_ts) — TIMESTAMP
  • status — ENUM('P', 'C', 'F')