ArtMarket

Tables (3)

Art (Art Contents)

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

Art Display (Art Display History)

  • Art Display Id (art_display_id) — int(8) — Primary key — NOT NULL
  • Art Display Name (art_display_name) — varchar(255)
  • Field

Artist (Artist Detail)

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