painting_exhibition_service

Tables (6)

Untitled (User)

  • Key (User_PK) — PK — Primary key — NOT NULL
  • Field (username) — CharField
  • Field (password) — CharField

Untitled (Artist)

  • Key (Artist_PK) — PK — Primary key — NOT NULL
  • Key (User_PK) — PK — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — CharField
  • Field (gender) — CharField
  • Field (birthday) — DateField
  • Field (email) — RegexValidator
  • Field (phone) — RegexValidator

Untitled (status)

  • Key (Status_PK) — PK — Primary key — NOT NULL
  • Field (status) — CharField

Untitled (Applicant)

  • Key (Applicant_PK) — PK — Primary key — NOT NULL
  • Key (User_PK) — FK — Foreign key → Untitled.Key — NOT NULL
  • Key (Status_PK) — FK — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — CharField
  • Field (gender) — CharField
  • Field (birthday) — DateField
  • Field (email) — RegexValidator
  • Field (phone) — RegexValidator
  • Field (apply_date) — DateTimeField

Untitled (Art)

  • Key (Art_PK) — PK — Primary key — NOT NULL
  • Key (Artist_PK) — PK — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — CharField
  • Field (price) — IntegerField
  • Field (size) — integerField

Untitled (Exhibition)

  • Key (exhibition_PK) — PK — Primary key — NOT NULL
  • Key (Writer_PK) — PK — Foreign key → Untitled.Key — NOT NULL
  • Key (Painting_PK) — PK — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — CharField
  • Field (start_date) — DateField
  • Field (end_date) — Date_Field