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