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