努力学习第十天
今日完成:
一、学习AS的各种布局方法。并找到想要的登陆界面。
二、创建数据库。完成对数据库实体、主键的分析。
Create database CarPooling;
use CarPooling;
create table OrderLists (
OrderID int auto_increment Primary key,
PoolingDate date,
PoolingTime int check(PoolingTime>=0 and PoolingTime<=23),
Depart varchar(40),
Dest varchar(40),
EndDate date,
EndTime int check(EndTime>=0 and Endtime<=23),
OState int check(State in (0,1,2)),
PersonNum int,
fee decimal(5,2),
CarID varchar(10),
Note varchar(100)
);
create table OrdersofUsers (
OrderID int,
UserID varchar(12),
isJoin boolean,
primary key(OrderID,UserID)
);
create table Users (
UserID varchar(12),
Pwd varchar(20),
Nickname varchar(10),
phone int,
school varchar(20),
RealName varchar(10),
Portrait varchar(512),
primary key(UserID)
);
create table Complainments (
ComplainID int auto_increment primary key,
UserID varchar(12),
OrderID int,
ComplainedUserID int,
Cstate int check(Cstate in (0, 1, 2)),
Ctime date
)