财政年度表之建表约束
程序员文章站
2022-05-26 20:58:26
...
财政年度表约束 无 Create Table FinancialYear(fiscal_year INTEGER NOT NULL PRIMARY KEY,start_date DATE NOT NULL,CHECK ((EXTRACT(YEAR FROM start_date)=fiscal_year-1)AND (EXTRACT (MONTH FROM start_date)=10)AND (EXTRACT(DAY FROM start_date)=1),
财政年度表约束Create Table FinancialYear (fiscal_year INTEGER NOT NULL PRIMARY KEY, start_date DATE NOT NULL, CHECK ((EXTRACT(YEAR FROM start_date)=fiscal_year-1) AND (EXTRACT (MONTH FROM start_date)=10) AND (EXTRACT(DAY FROM start_date)=1), end_date DATE NOT NULL, CONSTRAINT valid_end_date CHECK ((EXTRACT (YEAR FROM end_date)=fiscal_year) AND (EXTRACT (MONTH FROM end_date)=9) AND (EXTRACT (DAY FROM end_date)=30)))