0430_KDTstudy
Tables (21)
Category (장르)
- category_id (Key) — INT — Primary key — NOT NULL
- category_name (Field) — VARCHAR(20)
Comment (Untitled10)
- comment_idx (Key) — INT — Primary key — NOT NULL
- post_idx (Key2) — INT — Foreign key → Post.post_idx — NOT NULL
- User_code (Key3) — INT — Foreign key → User.User_code — NOT NULL
- User_code (Key32) — INT — Foreign key → Post.User_code — NOT NULL
- msg (Field2) — VARCHAR(50)
Film_distributor (배급사)
- Film_distributor_id (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(20)
Follow (Untitled12)
- follower_idx (Key) — INT — Primary key — NOT NULL
- User_code_follower (Key2) — INT — Foreign key → User.User_code — NOT NULL
- User_code_following (Key3) — INT — Foreign key → User.User_code — NOT NULL
Grade (좌석)
- Grade_code (Key) — INT — Primary key — NOT NULL
- grade (Field) — VARCHAR(10)
- discount (Field2) — INT
Hall (방)
- Hall_code (Key) — INT — Primary key — NOT NULL
- theater_id (Key2) — INT — Foreign key → Theater.theater_id — NOT NULL
- room_number (Field) — INT
- Seat_cnt (Field2) — INT
Hash_tag (Untitled9)
- hash_tag_idx (Key) — INT — Primary key — NOT NULL
- hash_name (Field) — VATCHAR(20)
Like (Untitled11)
- Like_idx (Key) — INT — Primary key — NOT NULL
- post_idx (Key2) — INT — Foreign key → Post.post_idx — NOT NULL
- User_code (Key3) — INT — Foreign key → User.User_code — NOT NULL
Member (회원)
- member_code (Key) — INT — Primary key — NOT NULL
- Grade_code (Key2) — INT — Foreign key → Grade.Grade_code — NOT NULL
- name (Field) — VARCHAR(20)
- tel (Field2) — VARCHAR(11)
- age (Field3) — INT
Movie (영화목록)
- Movie_code (Key) — INT — Primary key — NOT NULL
- Film_distributor_id (Key2) — INT — Foreign key → Film_distributor.Film_distributor_id — NOT NULL
- director_id (Key3) — INT — Foreign key → director.director_id — NOT NULL
- title (Field) — VARCHAR(30)
Movie-location (Untitled3)
- Movie_code (Key) — INT — Foreign key → Movie.Movie_code — NOT NULL
- Hall_code (Key2) — INT — Foreign key → Hall.Hall_code — NOT NULL
- theater_id (Key22) — INT — Foreign key → Hall.theater_id — NOT NULL
Movie_Category (Untitled2)
- category_id (Key) — INT — Foreign key → Category.category_id — NOT NULL
- Movie_code (Key2) — INT — Foreign key → Movie.Movie_code — NOT NULL
Movie_time (상영시간)
- Movie_time_id (Key) — INT — Primary key — NOT NULL
- Movie_code (Key2) — INT — Foreign key → Movie-location.Movie_code — NOT NULL
- Hall_code (Key22) — INT — Foreign key → Movie-location.Hall_code — NOT NULL
- theater_id (Key222) — INT — Foreign key → Movie-location.theater_id — NOT NULL
- start_time (Field) — INT
- end_time (Field2) — INT
- day (Field3) — DATE
- exists_seat_cnt (Field4) — INT
- price (Field5)
Order (Untitled4)
- Order_idx (Key) — INT — Primary key — NOT NULL
- member_code (Key2) — INT — Foreign key → Member.member_code — NOT NULL
- Grade_code (Key22) — INT — Foreign key → Member.Grade_code — NOT NULL
Photo (Untitled7)
- photo_idx (Key) — INT — Primary key — NOT NULL
- post_idx (Key2) — INT — Foreign key → Post.post_idx — NOT NULL
- User_code (Key3) — INT — Foreign key → Post.User_code — NOT NULL
- photo (Field) — FILE
Post (Untitled6)
- post_idx (Key) — INT — Primary key — NOT NULL
- User_code (Key3) — INT — Foreign key → User.User_code — NOT NULL
- text (Field) — VARCHAR(500)
Post_hash (Untitled8)
- post_info_idx (Key4) — INT — Primary key — NOT NULL
- post_idx (Key) — INT — Foreign key → Post.post_idx — NOT NULL
- hash_tag_idx (Key3) — INT — Foreign key → Hash_tag.hash_tag_idx — NOT NULL
- User_code (Key32) — INT — Foreign key → Post.User_code — NOT NULL
Theater (지역)
- theater_id (Key) — INT — Primary key — NOT NULL
- theater_name (Field) — VARCHAR(50)
Ticket (Untitled)
- Ticket_code (Key4) — INT — Primary key — NOT NULL
- Order_idx (Key3) — INT — Foreign key → Order.Order_idx — NOT NULL
- member_code (Key23) — INT — Foreign key → Order.member_code — NOT NULL
- Grade_code (Key223) — INT — Foreign key → Order.Grade_code — NOT NULL
- Movie_time_id (Key) — INT — Foreign key → Movie_time.Movie_time_id — NOT NULL
- Movie_code (Key2) — INT — Foreign key → Movie_time.Movie_code — NOT NULL
- Hall_code (Key22) — INT — Foreign key → Movie_time.Hall_code — NOT NULL
- theater_id (Key222) — INT — Foreign key → Movie_time.theater_id — NOT NULL
User (Untitled5)
- User_code (Key) — INT — Primary key — NOT NULL
- user_name (Field) — VARCHAR(20)
- user_nickname (Field2) — VARCHAR(20)
- user_email (Field3) — VARCHAR(30)
director (감독)
- director_id (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(20)