11 lines
375 B
SQL
11 lines
375 B
SQL
-- Depreciation rate on assets + widen depreciation_method for OTHER
|
|
|
|
ALTER TABLE assets
|
|
ADD COLUMN IF NOT EXISTS depreciation_rate NUMERIC(8, 4);
|
|
|
|
ALTER TABLE assets
|
|
ALTER COLUMN depreciation_method TYPE VARCHAR(20);
|
|
|
|
COMMENT ON COLUMN assets.depreciation_method IS 'SLM, WDV, OTHER';
|
|
COMMENT ON COLUMN assets.depreciation_rate IS 'Annual depreciation rate percentage';
|