erd
Tables (7)
Band (Untitled3)
- bandId (Key) — Long — Primary key — NOT NULL
- name (Field) — varchar(10)
- bandStyle (Field4) — varchar(30)
- intro (Field2) — varchar(100)
- maximumMembers (Field3) — Int
- minimumMembers (Field8) — int
- image (Field5)
- region (Field6) — varchar(30)
- genre (Field7) — varchar(10)
BandPhoto (CopyOfUntitled5)
- photoId (Key) — Long — Primary key — NOT NULL
- bandId (Key2) — Long — Foreign key → Band.bandId — NOT NULL
- url (Field)
Bandmembership (Untitled2)
- membershipId (Key) — Long — Primary key — NOT NULL
- memberId (Key2) — Long — Foreign key → Member.memberId — NOT NULL
- bandId (Key3) — Long — Foreign key → Band.bandId — NOT NULL
- role (Field) — varchar(10)
- status (Field2) — varchar(10)
- Introduction (Field3) — varchar(100)
- DesiredPosition (Field4) — varchar(30)
Member (Untitled)
- memberId (Key2) — Long — Primary key — NOT NULL
- id (Field) — varchar(30)
- password (Field2) — varchar(30)
- intro (Field3) — varchar(100)
- tag (Field4)
Photo (Untitled5)
- photoId (Key) — Long — Primary key — NOT NULL
- postId (Key2) — Long — Foreign key → Post.postId — NOT NULL
- url (Field)
Position (Untitled6)
- PositionId (Key) — Long — Primary key — NOT NULL
- bandId (Key2) — Long — Foreign key → Band.bandId — NOT NULL
- membershipId (Key3) — Long — Foreign key → Bandmembership.membershipId — NOT NULL
- name (Field) — varchar(10)
- IsDefault (Field2) — Bool
Post (Untitled4)
- postId (Key) — Long — Primary key — NOT NULL
- memberId (Key2) — Long — Foreign key → Member.memberId — NOT NULL
- content (Field) — varchar(300)
- dateTime (Field2)