create.sql

来自「ESQL包 PostgreSQL jsp servlet javaBean 数据」· SQL 代码 · 共 14 行

drop table member;

create table member
(
	member_no		char(10),
	password		char(20),
	gender			char(1)		default '男',
	name			varchar(40),
	address			varchar(255),
	phone_number	varchar(20),
	
	check (gender in ('男','女')),
	primary key(member_no)
);