자산관리

테이블 (4)

Assets

  • asset_id — TEXT
  • current_location_type — TEXT
  • current_location_id — TEXT — NOT NULL
  • status — TEXT
  • is_active — BOOLEAN
  • last_updated — DATETIME

Movements

  • move_id — INTEGER
  • asset_id — TEXT — NOT NULL
  • date — DATE — NOT NULL
  • category — TEXT
  • from_type — TEXT
  • from_id — TEXT
  • to_type — TEXT
  • to_id — TEXT
  • handler — TEXT
  • remarks — TEXT

Offices

  • office_id — TEXT
  • type — TEXT

Users

  • user_id — TEXT
  • name — TEXT — NOT NULL
  • team — TEXT — NOT NULL