IYP
Tables (11)
tbl_inyeon_fboard (free_board)
- fb_num — int — Primary key — NOT NULL
- fb_title — varchar2(300)
- fb_cont — varchar2(4000)
- fb_hit — int
- fb_date — sysdate
- email — varchar2(30) — Foreign key → tbl_inyeon_user.email — NOT NULL
- fb_img_url — varchar2(2000) — 서버에 저장될 이미지 경로
- Field
tbl_inyeon_freply (free_board_reply)
- freply_num — int — Primary key — NOT NULL
- free_board_num — int
- fb_reply_cont — varchar2(200)
- fb_reply_date — varchar2(20)
- fb_reply_reply — varchar2(400)
- free_board_num (free_board_num3) — int — Foreign key → tbl_inyeon_fboard.fb_num — NOT NULL
- fb_img_url — varchar2(2000)
- Field
tbl_inyeon_nboard (notice_board)
- nb_num — int — Primary key — NOT NULL
- nb_title — varchar2(30)
- nb_cont — varchar2(2000)
- nb_hit — int
- nb_date — varchar2(20)
- nb_img_url — varchar(2000)
- email — varchar2(30) — Foreign key → tbl_inyeon_user.email — NOT NULL
tbl_inyeon_pay_cancel (Untitled2)
- cancel_code — varchar(50) — Primary key — NOT NULL
- total_cost — int
- pay_date — vartchar(20)
- cancel_date — varchar(20)
- Field
- email — varchar2(100) — Foreign key → tbl_inyeon_user.email — NOT NULL
tbl_inyeon_payment (payment)
- pay_code — varchar2(100) — Primary key — NOT NULL — 영화 한 이메일에 여러개 예매하려고 복합키로 둠
- email — varchar2(100) — Primary key — NOT NULL
- pay_way — varchar2(10)
- total_cost — int
- pay_date — varchar2(20)
- res_code — varchar2(20) — Foreign key → tbl_inyeon_reservation.res_code — NOT NULL
- Field
tbl_inyeon_pboard (prom_board)
- pb_num — int — Primary key — NOT NULL
- pb_title — varchar2(30)
- pb_cont — varchar2(2000)
- pb_hit — int
- pb_date — sysdate
- pb_img_url — varchar(2000)
- email (email2) — varchar2(100) — Foreign key → tbl_inyeon_user.email — NOT NULL
tbl_inyeon_point (Untitled)
- point_code — varchar2(30) — Primary key — NOT NULL
- point_cont — varchar2(300)
- point_date — varchar2(20)
- point — int
- Field
- email — varchar2(100) — Foreign key → tbl_inyeon_user.email — NOT NULL
tbl_inyeon_preftheater (pref_theater)
- email — varchar2 — Primary key — NOT NULL
- pref_theater01 — varchar2(100)
- pref_theater02 — varchar2(100)
- pref_theater03 — varchar2(100)
tbl_inyeon_reservation (reservation)
- res_code — varchar2(20) — Primary key — NOT NULL
- ticket_code — varchar2(20) — Foreign key → tbl_inyeon_ticket.ticket_code — NOT NULL
- ticket_code2 — varchar2(20) — Foreign key → tbl_inyeon_ticket.ticket_code — NOT NULL
- ticket_code3 — varchar2(20) — Foreign key → tbl_inyeon_ticket.ticket_code — NOT NULL
- ticket_code4 — varchar2(20) — Foreign key → tbl_inyeon_ticket.ticket_code — NOT NULL
tbl_inyeon_ticket (ticket)
- ticket_code — varchar2(20) — Primary key — NOT NULL
- cost — int
- seat — varchar2(20)
- location — varchar2(20)
- location_code — varchar2(20)
- Field
tbl_inyeon_user (member)
- email — varchar2(100) — Primary key — NOT NULL
- password — varchar2(100)
- username — varchar2(100)
- sub_date — sysdate
- total_point — int
- user_key — varchar2(200)
- user_sort_code — int
- pref_code — varchar2(100) — Foreign key → tbl_inyeon_preftheater.email — NOT NULL
- email (email2) — varchar2(100) — Foreign key → tbl_inyeon_payment.email — NOT NULL
- cell_phone — varchar2(50)
- login_way — int
- Field
- email (email3) — varchar2 — Foreign key → tbl_inyeon_preftheater.email — NOT NULL