자산관리
테이블 (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