111

테이블 (17)

CopyOfmusical

  • musical_number — number — 기본 키 — NOT NULL
  • musical_title — varchar(100) — NOT NULL
  • musical_content — varchar(2000)
  • musical_audience_age — number
  • musical_price — VARCHAR(255) — NOT NULL — 타입고민
  • musical_perform_date — varchar(100) — NOT NULL
  • musical_show_date — date — NOT NULL — 타입고민
  • musical_end_date — date — NOT NULL — 타입고민
  • musical_ganre — varchar(20)

QnA (질의응답)

  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6

Untitled (등급)

  • Field
  • Field2

User

  • user_number — number — 기본 키 — NOT NULL — 사용자 번호
  • user_id — varchar2(50) — NOT NULL
  • user_password — varchar2(50) — NOT NULL
  • user_name — varchar2(50) — NOT NULL
  • user_email — varchar2(50)
  • user_phone — varchar2(50)
  • register_date — date — NOT NULL — 타입고민
  • admin — varchar2(10) — 관리자인지 여부 Y/N
  • register_id — varchar2(50)
  • modifier_id — varchar2(50)
  • modify_date — date
  • email_verified — varchar2(2)
  • verification_code — varchar2(50)
  • verification_expiry — date
  • is_deleted — varchar2(2)

address

  • address_number — number — 기본 키 — NOT NULL
  • city_name — number — 외래 키 → city_address.city-name — NOT NULL
  • country_name — varchar(50) — NOT NULL

admin

  • admin_number — number — 기본 키 — NOT NULL
  • admin_id — varchar2(50) — NOT NULL
  • admin_password — varchar2(50) — NOT NULL

art_img

  • arts_img_number — number — 기본 키 — NOT NULL
  • img_name — varchar(100) — NOT NULL

arts_comment

  • arts_number — number — 기본 키 — NOT NULL
  • musical_number — number — 외래 키 → musical.musical_number — NOT NULL
  • arts_board_content — varchar(1000) — NOT NULL
  • arts_board_register_date — VARCHAR(255) — NOT NULL — 타입고민
  • arts_board_update_date — VARCHAR(255) — NOT NULL — 타입고민
  • arts_rating — number — NOT NULL
  • arts_count — number — 필요하면 넣고 아니면 말고

arts_img_addr

  • img_addr_number — number — 기본 키 — NOT NULL
  • arts_img_number — number — 외래 키 → art_img.arts_img_number — NOT NULL
  • img_file_name — varchar(100) — NOT NULL
  • img_upload_path — varchar(100) — NOT NULL

cast_info

  • cast_info_number — number — 기본 키 — NOT NULL
  • cast_name — varchar(20) — NOT NULL
  • cast_gender — varchar(10) — NOT NULL
  • Field — VARCHAR(255) — 고민해보기

cast_info_img

  • img_addr_number — number — 기본 키 — NOT NULL
  • cast_info_number — number — 외래 키 → cast_info.cast_info_number — NOT NULL
  • img_file_name — varchar(100) — NOT NULL
  • img_upload_path — varchar(100) — NOT NULL

city_address

  • city-name — number — 기본 키 — NOT NULL
  • city_name — varchar(100) — NOT NULL

musical

  • musical_number — number — 기본 키 — NOT NULL
  • address_number — number — 외래 키 → address.address_number — NOT NULL
  • cast_info_number — number — 외래 키 → cast_info.cast_info_number — NOT NULL
  • musical_title — varchar(100) — NOT NULL
  • musical_content — varchar(2000)
  • musical_audience_age — number
  • musical_price — number — NOT NULL — 타입고민
  • musical_perform_date — varchar(100) — NOT NULL
  • musical_show_date — date — NOT NULL — 타입고민
  • musical_end_date — date — NOT NULL — 타입고민
  • musical_ganre — varchar(20)

notice

  • notice_number — number — 기본 키 — NOT NULL
  • notice_title — varchar2(100) — NOT NULL
  • notice_content — varchar2(2000)
  • notice_register_date — date
  • notice_modify_date — date

purchase

  • ticket_number — VARCHAR(255) — 기본 키 — NOT NULL
  • user_number2 — number — 외래 키 → User.user_number — NOT NULL
  • musical_number — number — 외래 키 → musical.musical_number — NOT NULL
  • address_number — number — 외래 키 → musical.address_number — NOT NULL
  • cast_info_number — number — 외래 키 → musical.cast_info_number — NOT NULL
  • ticket_date — VARCHAR(255) — NOT NULL — 타입고민
  • Field — VARCHAR(255)

tt

  • musical_number — number — 기본 키 — NOT NULL
  • address_number — number — 외래 키 → address.address_number — NOT NULL
  • cast_info_number — number — 외래 키 → cast_info.cast_info_number — NOT NULL
  • musical_title — varchar(100) — NOT NULL
  • musical_content — varchar(2000)
  • musical_audience_age — number
  • musical_price — VARCHAR(255) — NOT NULL — 타입고민
  • musical_perform_date — varchar(100) — NOT NULL
  • musical_show_date — date — NOT NULL — 타입고민
  • musical_end_date — date — NOT NULL — 타입고민

할인

  • Field
  • Field2
  • Field3
  • Field4