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')