createtable.sql

来自「该票务系统包括的功能有网上订票、历史订阅纪录查询、近期上映影片推荐和查询和统计报」· SQL 代码 · 共 77 行

create table employee
	(	emp_no    NUMBER(10, 0)    NOT NULL,
    	emp_name     VARCHAR2(30)     NOT NULL,
    	emp_password     VARCHAR2(30)     NOT NULL,
    	primary key (emp_no)
 	);
create table film
	(
		film_id		NUMBER(10,0)	NOT NULL,
		film_name	VARCHAR2(30)	NOT NULL,
		Country		VARCHAR2(30)	NOT NULL,
		director 	VARCHAR2(30)	NOT NULL,
		actor		VARCHAR2(30)	NOT NULL,
		length		NUMBER(30,0)		NOT NULL,
		primary key (film_id)
	);

create table room
	(
		room_num	NUMBER(10,0)	NOT NULL,
		total_seat	NUMBER(10,0)	NOT NULL,
		primary key	(room_num)
	);

create table ticket
	(
		ticket_id	NUMBER(10,0)	NOT NULL,
		film_name   VARCHAR2(30)	NOT NULL,
		section		NUMBER(10,0)	NOT NULL,
		seat		NUMBER(10,0)	NOT NULL,
		on_time		DATE			NOT NULL,
		room		NUMBER(10,0)	NOT NULL,
		money		NUMBER(10,0)	NOT NULL,
		sold		CHAR(10)		NOT NULL,
		primary key (ticket_id)
	);

create table Customer
	(
		customer_id		NUMBER(10,0)	NOT NULL,
		user_name		VARCHAR2(30)	NOT NULL,
		password        VARCHAR2(30)	NOT NULL,
		e_mail			VARCHAR2(40)	NOT NULL,
		money			NUMBER(10,0)	NOT NULL,
		primary key (customer_id)
	);

create table arrange
	(
		a_id			NUMBER(10,0)	NOT NULL,
		section			NUMBER(10,0)	NOT NULL,
		emp_no			NUMBER(10,0)	NOT NULL,
		arrange_time    DATE			NOT NULL,
		primary key (a_id)
	);

create table show
	(
		section		NUMBER(10,0)	NOT NULL,
		film_id		NUMBER(10,0)	NOT NULL,
		room_num	NUMBER(10,0)	NOT NULL,
		on_time		Date			NOT NULL,
		end_time	Date			NOT NULL,
		primary key (section)
	);

create table bookRecord
	(
	  	record_id	NUMBER(10,0)	NOT NULL,
	  	customer_id	NUMBER(10,0)	NOT NULL,
	  	ticket_id	NUMBER(10,0)	NOT NULL,
	  	sell_prize	NUMBER(10,0)		NOT NULL,
	  	sell_time	Date			NOT NULL,
	  	primary key (record_id)
	);