Moventory
테이블 (8)
Mini PC 이력 (mini_pc_history)
- id — SERIAL — 기본 키 — NOT NULL — auto increment
- category (category2) — TEXT — 외래 키 → category.category — NOT NULL
- asset_number — TEXT — NOT NULL
- location — TEXT — 외래 키 → location.location — NOT NULL
- is_return — Boolean
- name — TEXT — 외래 키 → user_name.name — NOT NULL
- purpose — TEXT — 외래 키 → puerpose.purpose — NOT NULL
- use_date — Date — NOT NULL
- return_date — Date
- history — TEXT — NOT NULL
- writer — TEXT — NOT NULL
- create_time — Timestamp — NOT NULL
- test_importance — integer — constraint mini_pc_history_test_importance_check check ((test_importance >= 1) AND (test_importance <= 5)
category
- category — TEXT — 기본 키 — NOT NULL
location
- location — TEXT — 기본 키 — NOT NULL
puerpose
- purpose — TEXT — 기본 키 — NOT NULL
user_name
- name — TEXT — 기본 키 — NOT NULL
외장저장소 이력 (storage_history)
- id — SERIAL — 기본 키 — NOT NULL — auto increment
- category (category2) — TEXT — 외래 키 → category.category — NOT NULL
- asset_number — TEXT — NOT NULL
- location — TEXT — 외래 키 → location.location — NOT NULL
- is_return — Boolean
- name — TEXT — 외래 키 → user_name.name — NOT NULL
- purpose — TEXT — 외래 키 → puerpose.purpose — NOT NULL
- use_date — Date — NOT NULL
- return_date — Date
- history — TEXT — NOT NULL
- writer — TEXT — NOT NULL
- create_time — Timestamp — NOT NULL
초음파센서 이력 (sensor_history)
- id — SERIAL — 기본 키 — NOT NULL — auto increment
- category (category2) — TEXT — 외래 키 → category.category — NOT NULL
- asset_number — TEXT — NOT NULL
- location — TEXT — 외래 키 → location.location — NOT NULL
- is_return — Boolean
- name — TEXT — 외래 키 → user_name.name — NOT NULL
- purpose — TEXT — 외래 키 → puerpose.purpose — NOT NULL
- use_date — Date — NOT NULL
- return_date — Date
- history — TEXT — NOT NULL
- writer — TEXT — NOT NULL
- create_time — Timestamp — NOT NULL
포터블모니터 이력 (portable_history)
- id — SERIAL — 기본 키 — NOT NULL — auto increment
- category (category2) — TEXT — 외래 키 → category.category — NOT NULL
- asset_number — TEXT — NOT NULL
- location — TEXT — 외래 키 → location.location — NOT NULL
- is_return — Boolean
- name — TEXT — 외래 키 → user_name.name — NOT NULL
- purpose — TEXT — 외래 키 → puerpose.purpose — NOT NULL
- use_date — Date — NOT NULL
- return_date — Date
- history — TEXT — NOT NULL
- writer — TEXT — NOT NULL
- create_time — Timestamp — NOT NULL