ㅁㄴㅇㄹ
Tables (5)
code_dictionary
- c_type — varchar — Primary key — NOT NULL
- c_category — varchar
- c_type_name — varchar — NOT NULL
- c_code — int — NOT NULL
- c_name — varchar — NOT NULL
- c_order — int
- c_used — varchar
- Field — VARCHAR(255)
m_evaluation
- me_no — int — Primary key — NOT NULL
- me_grade — int — NOT NULL
- me_post — varchar — NOT NULL
- m_no — int — Foreign key → movie.m_no
movie
- m_no — int — Foreign key → movie.m_no — NOT NULL
- m_name — varchar — NOT NULL
- m_actor — varchar — NOT NULL
- m_director — varchar — NOT NULL
- m_release_date — date — NOT NULL
- m_deadline — date
- m_status — int — NOT NULL
- m_showtime — int — NOT NULL
- m_detailedplot — varchar — NOT NULL
- m_plot — varchar — NOT NULL
- m_numberlikes — int — NOT NULL
- m_viewers — int — NOT NULL
movie_code
- m_no — int — Foreign key → movie.m_no — NOT NULL
- c_type — varchar — Foreign key → code_dictionary.c_type — NOT NULL
movie_image
- m_no — int — NOT NULL
- m_image — varchar — NOT NULL