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)