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)