ZAMAR

ZAMAR 의 postgre SQL ERD

테이블 (4)

Band Member table (Untitled4)

  • Field

Band information (Untitled2)

  • id — int — 기본 키 — NOT NULL — PK id
  • memberFK — 기본 키 — member field table FK
  • id (id2) — int — 외래 키 → User Information.id — NOT NULL — Auto Increase
  • score id (Field3) — int — 외래 키 → User Information.score id — Saved Scores id
  • Band Name (bname) — varchar — Band Name
  • Host Name (hname) — varchar — Band Host

Score Infomation (Untitled3)

  • id — int — 기본 키 — NOT NULL — Auto Increase
  • score id (FK) — int — 외래 키 → User Information.score id — Saved Scores id
  • name — varchart — NOT NULL — Score name
  • Field2 (s3 url) — varchart — NOT NULL — Saved Scrore's S33 URL
  • Field

User Information (Untitled)

  • id — int — 기본 키 — NOT NULL — Auto Increase
  • score id (Field3) — int — 기본 키 — Saved Scores id
  • email — varchart — NOT NULL — Log in Email
  • password — varchart — NOT NULL — Log in Password
  • Band (band)
  • Field5