oracle阶段性学习 这周末的作业

系统中基金公司表（FundCompany）
create table fc(
companyid varchar2(20) primary key,
name varchar2(30) not null,
content clob not null,
money number(10,2),
state number(1,0) check (state=0 or state=1)
);

系统中基金表（Fund）
create table fund(
fundno varchar2(20) primary key,
companyid varchar2(20) references fc(companyid),
fundname varchar2(20),
price number(10,2),
fundtype number(1,0) check (fundtype=1 or fundtype=0),
invest number(1,0) check (invest=1 or invest=2 or invest=3 or invest=4),
buylimit number(5,0),
ischange number(1,0) check (ischange=1 or ischange=0),
yearrate number(6,5) check (yearrate=1 or yearrate=0),
applydate date,
state number(1,0) check (state=1 or state=0)
);

--系统中活期帐户表（CurrentAccount）
create table ca(
currentaccount varchar2(20) primary key,
currentpassword varchar2(20),
depositsum number(10,2),
cardtype number(1,0) check (cardtype=1 or cardtype=2 or cardtype=3),
cardno varchar2(20),
name varchar2(10),
address varchar2(100),
phone varchar2(20),
openaccdate date,
state number(1,0) check (state=1 or state=0)
);

--系统中理财账户表（FinancingAccount）

create table fa(
financingaccount varchar2(20) primary key,
financepassword varchar2(20),
moneytype number(1,0) check (moneytype=1 or moneytype=2 or moneytype=3),
accountbalance number(10,2),
enablebalance number(10,2),
congealfund number(10,2),
state number(1,0) check (state=1 or state=0),
currentaccount varchar2(20) references ca(currentaccount)
);

系统中基金账户表（FundAccount）
create table fat(
fundaccount varchar2(20) primary key,
financingaccount varchar2(20) references fa(financingaccount),
companyid varchar2(20) references fc(companyid),
cardtype number(1,0) check (cardtype=1 or cardtype=2 or cardtype=3),
cardno varchar2(20) not null,
name varchar2(10) not null,
sex number(1,0) check (sex=1 or sex=2),
address varchar2(100),
phone varchar2(20),
postnum varchar2(10),
email varchar2(30) not null,
createdate date,
congeaistate number(1,0) check (congeaistate=1 or congeaistate=0)
);

系统中购买的基金表（FundBuy）
create table fb(
pactno varchar2(20) primary key,
financingaccount varchar2(20) references fa(financingaccount),
fundno varchar2(20) references fund(fundno),
fundname varchar2(20),
fundnumber number(5,0),
buydate date,
state number(1,0) check (state=0 or state=1)
);

--系统中交易表（Trade）
create table trade(
pactno varchar2(20) references fb(pactno),
financingaccount varchar2(20) references fa(financingaccount),
fundno varchar(20) references fund(fundno),
fundname varchar(20),
dealtype number(1,0) check (dealtype=1 or dealtype=2 or dealtype=3),
fundquptient number(5,0),
bargainprice number(10,2),
dealmoney number(10,20),
fundaccount varchar2(20) references fat(fundaccount),
dealdate date,
status number(1,0) check （status=0 or status=1)
);

oracle阶段性学习 这周末的作业

标签：char   cin   har   gac   varchar   apply   dea   ble   create