3팀
테이블 (5)
inquiry (문의 사항)
- Key (BIGINT) — BIGINT — 기본 키 — NOT NULL
- title (VARCHART) — VARCHART
- quantity (INTEGER) — INTEGER
- status (DECIMAL) — DECIMAL
- min_quantity (Field5) — INTEGER
- inventory (BIGINT2) — BIGINT — 외래 키 → inventory.inventory — NOT NULL — FK 외래키 inventory
inventory (재고)
- inventory (BIGINT) — BIGINT — 기본 키 — NOT NULL
- product_name (VARCHART) — VARCHART
- quantity (INTEGER) — INTEGER
- unit_price (DECIMAL) — DECIMAL
- min_quantity (Field5) — INTEGER
- Field
inventory_arrival (재고 도착 정보)
- Key (BIGINT) — BIGINT — 기본 키 — NOT NULL
- product_name (VARCHART) — VARCHART
- quantity (INTEGER) — INTEGER
- supplier_name (DECIMAL) — DECIMAL
- min_quantity (Field5) — INTEGER
- inventory (inventory_id) — BIGINT — 외래 키 → inventory.inventory — NOT NULL — FK 재고 외래키
notification (알림)
- Key (BIGINT) — BIGINT — 기본 키 — NOT NULL
- title (VARCHART) — VARCHART
- quantity (INTEGER) — INTEGER
- status (DECIMAL) — DECIMAL
- min_quantity (Field5) — INTEGER
- inventory (BIGINT2) — BIGINT — 외래 키 → inventory.inventory — NOT NULL
notification (모니터링)
- monitoring_id — BIGINT — 기본 키 — NOT NULL
- check_date (VARCHART) — TIMESTAMP
- quantity (INTEGER) — INTEGER
- status (DECIMAL) — VARCHAR
- notes (Field5) — TEXT
- inventory (BIGINT) — BIGINT — 외래 키 → inventory.inventory — NOT NULL