오픈갤러리

테이블 (4)

Art (Untitled3)

  • Key — 기본 키 — NOT NULL
  • user_id — FK — 외래 키 → Artist.user_id — NOT NULL
  • name — CharField
  • price — IntegerField
  • size — CharField
  • number (number(호수)) — IntegerField
  • image (FileField) — FileField

Artist (Untitled2)

  • Key — 기본 키 — NOT NULL
  • user_id — FK — 외래 키 → User.Key — NOT NULL
  • name — CharField(16자 이하)
  • gender — Boolean
  • birthday — Charfield
  • phone — Charfield
  • is_waiting (처리대기중) — BooleanField
  • is_confrimed (승인/ 반려) — BooleanField

Exhibition (CopyOfUntitled3)

  • Key — 기본 키 — NOT NULL
  • user_id — FK — 외래 키 → Artist.user_id — NOT NULL
  • art_list — MTM — 외래 키 → Art.Key — NOT NULL
  • user_id (user_id2) — FK — 외래 키 → Art.user_id — NOT NULL
  • start_date — DateTimeField
  • end_date — DateTimeField

User (Untitled)

  • Key — 기본 키 — NOT NULL
  • username — CharField
  • password — CharField
  • Usertype1 (Field) — BooleanField
  • Usertype2 (Field2) — CharField