미술프로젝트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