创建记账本数据库各种表语句
时间: 2023-05-30 11:07:39 浏览: 72
以下是一些可能包含在记账本数据库中的表语句:
1. 用户表(User Table):
CREATE TABLE users (
id INT NOT NULL AUTO_INCREMENT,
username VARCHAR(255) NOT NULL,
password VARCHAR(255) NOT NULL,
email VARCHAR(255),
PRIMARY KEY (id)
);
2. 帐户表(Account Table):
CREATE TABLE accounts (
id INT NOT NULL AUTO_INCREMENT,
user_id INT NOT NULL,
name VARCHAR(255) NOT NULL,
balance DECIMAL(10,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (id),
FOREIGN KEY (user_id) REFERENCES users(id)
);
3. 收入表(Income Table):
CREATE TABLE income (
id INT NOT NULL AUTO_INCREMENT,
account_id INT NOT NULL,
name VARCHAR(255) NOT NULL,
amount DECIMAL(10,2) NOT NULL,
date DATE NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (account_id) REFERENCES accounts(id)
);
4. 支出表(Expense Table):
CREATE TABLE expense (
id INT NOT NULL AUTO_INCREMENT,
account_id INT NOT NULL,
name VARCHAR(255) NOT NULL,
amount DECIMAL(10,2) NOT NULL,
date DATE NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (account_id) REFERENCES accounts(id)
);
5. 转账表(Transfer Table):
CREATE TABLE transfers (
id INT NOT NULL AUTO_INCREMENT,
from_account_id INT NOT NULL,
to_account_id INT NOT NULL,
amount DECIMAL(10,2) NOT NULL,
date DATE NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (from_account_id) REFERENCES accounts(id),
FOREIGN KEY (to_account_id) REFERENCES accounts(id)
);
这些表可以根据需要进行更改和扩展。