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
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 — 타입고민