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