미술프로젝트DB
테이블 (11)
Art
- art_id — BIGINT — 기본 키 — NOT NULL
- art_name — varchar(64) — NOT NULL
- art_picture — mediumblob — NOT NULL
- made_year — Date
- art_size — VarChar(10)
- artist_id — BIGINT — 외래 키 → Artist.artist_id — NOT NULL
- drawing_method — varchar(32) — 외래 키 → Drawing_method.drawing_method
- art_style — varchar(32) — 외래 키 → Art_style.art_style
Art_description
- art_id — BIGINT — 외래 키 → Art.art_id — NOT NULL
- art_description — TEXT — NOT NULL
Art_style
- art_style — VarChar(32) — 기본 키 — NOT NULL
Artist
- artist_id — BIGINT — 기본 키 — NOT NULL
- artist_photo — mediumblob
- artist_name — VarChar(64) — NOT NULL
- artist_birthdeath — Date — NOT NULL
Artist_description
- artist_id — BIGINT — 외래 키 → Artist.artist_id — NOT NULL
- artist_description — TEXT — NOT NULL
Artist_nationality
- artist_id — BIGINT — 외래 키 → Artist.artist_id — NOT NULL
- country — VarChar(30) — NOT NULL
Drawing_method
- drawing_method — VarChar(32) — 기본 키 — NOT NULL
Search_keyword_list
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- search_keyword — VarChar(128)
User
- user_id — BIGINT — 기본 키 — NOT NULL
- profile_name — VarChar(64) — NOT NULL
- password — varchar(64) — NOT NULL
- user_email — varchar(32) — NOT NULL
- profile_photo — mediumblob
User_access_list
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- art_id — BIGINT — 외래 키 → Art.art_id — NOT NULL
User_review_list
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- art_id — BIGINT — 외래 키 → Art.art_id — NOT NULL
- rank — decimal — NOT NULL