create table member(
m_id varchar2(20) primary key,
m_pass varchar2(20) not null,
m_name varchar2(20) not null,
m_addr varchar2(20) not null,
m_pnum varchar2(20) not null,
logcheck char(1) default 0, check(logcheck = 0 or logcheck =1))
);
cerate table film (
f_no varchar2(6) primary key,
f_name varchar2(20) not null,
f_sline varchar2(100) not null,
f_oday varchar2(9) not null,
f_rated varchar2(4) check (f_rated in('g','pg','pg13','x')) not null,
f_rtime varchar2(9) not null
);
create table ticketing (
t_no number primary key,
t_theater varchar2(4) not null,
m_id varchar2(20),
f_no varchar2(6),
seat varchar2(4) not null,
foreign key (m_id) references member (m_id) on delete cascade,
foreign key (f_no) references film (f_no) on delete cascade
);
creeate table manager(
g_id varchar2(20) primary key,
g_pass varchar2(20) not null,
g_name varchar2(20) not null,
g_rank varchar2(4) not null
);
create sequence auto_num
incrment by 1
start with 1 ;
ㅇㅇ