財政年度表之建表約束
來源：懂視網
責編：小采
時間：2020-11-09 09:17:23
財政年度表之建表約束
財政年度表之建表約束: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 DAT
導讀財政年度表之建表約束: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 DAT
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)))
聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
財政年度表之建表約束
財政年度表之建表約束: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 DAT
