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)