ArtMarket - 2022-05-09 02:05:09

Tables (3)

Art (Art Contents)

  • Art Id (art_id) — int(4) — Primary key — NOT NULL
  • Artist Id (artists_id) — int(4) — Foreign key → Artist.Artist Id — NOT NULL
  • Display Id (display_id) — int(4) — Foreign key → Art Display.Display Id — NOT NULL
  • Artist Id (artists_id2) — int(4) — Foreign key → Art Display.Artist Id — NOT NULL
  • Art Name (art_name) — varchar(255)
  • Sales Price (price) — int(16)
  • Sale YN (sale_yn) — char(1)
  • Art Image (art_image)

Art Display (Art Display History)

  • Display Id (display_id) — int(4) — Primary key — NOT NULL
  • Artist Id (artists_id) — int(4) — Foreign key → Artist.Artist Id — NOT NULL
  • Display Name (display_name) — varchar(255)
  • Display Place (display_place) — varchar(255)
  • Display Date (display_date) — varchar(8)
  • Display Image (display_image)

Artist (Artist Detail)

  • Artist Id (artists_id) — int(4) — Primary key — NOT NULL
  • Artist Name (artist_name) — varchar(255)
  • Birth Date (birth_date) — varchar(8)
  • Last School (last_school) — varchar(255)