Column | Type | lenth | Remark |
---|---|---|---|
UserName | text | primary key | |
Password | text | ||
Permission | bool |
Column | Type | lenth | Remark |
---|---|---|---|
RoomNumber | int | primary key | |
Reservation | bool | ||
ReservationDate | datetime | ||
CheckIn | bool | ||
CheckInTime | datetime | ||
CheckEndTime | datetime | ||
PeopleNumber | int | NotNull | |
Remark | text |
Column | Type | lenth | Remark |
---|---|---|---|
RecordTime | datetime | primary key | |
RoomNumber | int | NotNull | |
Event | text | NotNull | |
State | text |
Column | Type | lenth | Remark |
---|---|---|---|
RoomNumber | int | primary key | |
Price | int | NotNull | |
VIP | int | 0%-100% Sale |
Column | Type | lenth | Remark |
---|---|---|---|
RecordTime | datetime | primary key | |
Name | text | NotNull | |
PersonID | text | 18 | NotNull |
Phone | text | 11 | NotNull |
Gender | bool | T=♂ NotNull | |
RoomNumber | int | NotNull | |
UseVIP | bool | defalut:F | |
State | text |
创建SQLite,完善数据库设计
合并VS项目与QTC项目 设计数据库
初始化项目