DROP TABLE IF EXISTS student;
CREATE TABLE student (
    id text NOT NULL,
    name text,
    phone text,
    sex smallint,
    age bigint
);

COMMENT ON TABLE student IS '学生表';
COMMENT ON COLUMN student.id IS '学号';
COMMENT ON COLUMN student.name IS '姓名';
COMMENT ON COLUMN student.phone IS '手机号';
COMMENT ON COLUMN student.sex IS '性别';
COMMENT ON COLUMN student.age IS '年龄';

TRUNCATE "student";
INSERT INTO "student" ("id", "name", "phone", "sex", "age") VALUES
('778daefe-ca9b-4d0b-9543-579ca7e9c986',	'张三峰',	'13888888888',	1,	105),
('a6dec4f6-f10d-42a8-8262-b539256d317d',	'张三峰',	'13888888888',	1,	105),
('5b8e0687-cd1d-45a2-9813-c015f0807c9c',	'张三峰',	'13888888888',	1,	105),
('c32303e5-408d-4dc6-95ef-49e88a7d647c',	'张三峰',	'13888888888',	1,	105),
('5cd15cff-c2e6-46c9-b67f-3dea09524735',	'张三峰',	'13888888888',	1,	105),
('af71328f-099e-4abf-af47-ec50a7816bad',	'张三峰',	'13888888888',	1,	105),
('9cd84fb3-176c-4543-8f0d-542961cbb14f',	'张三峰',	'13888888888',	1,	105),
('1a5cd675-ce6c-407c-b40e-50b04aad631a',	'张三峰',	'13888888888',	1,	105),
('007c444c-8401-4f08-84ac-5e6a8a5a8e91',	'张君宝',	'1388888888',	1,	108);