编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE student (
	id int,
	name varchar(255),
	address varchar(255),
	city varchar(255)
);

INSERT INTO student VALUES (1, '刘一', '郑十家隔壁', '河南');
INSERT INTO student VALUES (2, '陈二',  '李四家隔壁', '安徽');
INSERT INTO student VALUES (3, '张三',  '白娘子家隔壁', '杭州');
INSERT INTO student VALUES (4, '李四',  '许仙家隔壁', '杭州');
INSERT INTO student VALUES (5, '王五',  '李四家隔壁', '杭州');
INSERT INTO student VALUES (6, '赵六',  '赵六家隔壁', '杭州');
INSERT INTO student VALUES (7, '孙七',  '张三家隔壁', '杭州');
INSERT INTO student VALUES (8, '周八',  '雷峰塔附近', '杭州');
INSERT INTO student VALUES (9, '吴九',  '孙七家隔壁', '杭州');
INSERT INTO student VALUES (10, '郑十',  '周八家隔壁', '杭州');
 
SELECT * FROM student;

USE lhtz；
CREATE TATAB stock_industry(
    ts_code CHAR(6) NOT NULL PRIMARY KEY,
    code_name CHAR(8) NOT NULL,
    industry VARCHAR(8) NOT NULL);
    #雷含钰#

CREATE TABLE income(
    ts_code CHAR(6) NOT NULL,
    end_date DATE NOT NULL,
    oper_income DECIMAL(10,2),
    oper_cost DECIMAL(10,2),
    tax_surchg DECIMAL(10,2),
    sell_exp DECIMAL(10,2),
    admin_exp DECIMAL(10,2),
    fin_exp DECIMAL(10,2),
    operate_profit DECIMAL(10,2),
    non_oper_income DECIMAL(10,2),
    non_oper_cost DECIMAL(10,2),
    total_prodit DECIMAL(10,2),
    income_tax DECIMAL(10,2),
    net_profit DECIMAL(10,2),
    PRIMARY KEY(ts_code,end_date),
    CONSTRAINT fk_income FOREING KEY(ts_code) REFERENCES stock_industry(ts_code));
    #雷含钰#

CREATE TATAB balacencesheet(
    ts_code CHAR(6) NOT NULL,
    end_date DATE NOT NULL,
    cash_all DECIMAL(10,2),
    receivable DECIMAL(10,2),
    advances_suppliers DECIMAL(10,2),
    inventories DECIMAL(10,2),
    tol_cur_assets DECIMAL(10,2),
    long_equity DECIMAL(10,2),
    fixed_assets DECIMAL(10,2),
    intangible_assets DECIMAL(10,2),
    ono_cur_assets DECIMAL(10,2),
    assets DECIMAL(10,2),
    short_date DECIMAL(10,2),
    accounts_pay DECIMAL(10,2),
    payroll DECIMAL(10,2),
    interest DECIMAL(10,2),
    cur_liabilities DECIMAL(10,2),
    ono_cur_liabilities DECIMAL(10,2),
    liabilities DECIMAL(10,2),
    owners_equity DECIMAL(10,2),
    PRIMARY KEY(ts_code,end_date),
    CONSTRAINT fk_balance FOREING KEY(ts_code) REFERENCES stock_industry(ts_code));
    #雷含钰#