Odok

Tables (5)

Book (Untitled3)

  • bookId (PK) — Long — Primary key — NOT NULL
  • bookName (Field) — String
  • bookImage (Field2) — String
  • writer (Field3) — String
  • summary (Field4) — String
  • publisher (Field5) — String
  • createdAt (Field6) — Date
  • modifiedAt (Field7) — Date

Club (Untitled2)

  • clubId (PK) — Long — Primary key — NOT NULL
  • memberId (FK) — String — Foreign key → Member.memberId — NOT NULL
  • clubName (Field) — String
  • clubIntro (Field2) — String
  • plan (Field3) — String
  • location (Field4) — String
  • schedule (Field5) — String
  • memberLimit (Field6) — Long
  • category (Field7) — String
  • summary (Field8) — String
  • imageUrl (Field9) — String
  • createdAt (Field10) — Date
  • modifiedAt (Field11) — Date

Club_Member (Untitled5)

  • id (PK) — Long — Primary key — NOT NULL
  • clubId (FK) — Long — Foreign key → Club.clubId — NOT NULL
  • memberId (PK2) — String — Foreign key → Member.memberId — NOT NULL
  • memberId (PK22) — String — Foreign key → Club.memberId — NOT NULL

Club_book (Untitled4)

  • Id (PK) — Long — Primary key — NOT NULL
  • clubId (FK) — Long — Foreign key → Club.clubId — NOT NULL
  • bookId (FK2) — Long — Foreign key → Book.bookId — NOT NULL
  • memberId (PK2) — String — Foreign key → Club.memberId — NOT NULL

Member (Untitled)

  • memberId (PK) — String — Primary key — NOT NULL
  • email (Field) — String
  • username (Field2) — String
  • address (Field3) — String
  • phoneNumber (Field4) — String
  • password (Field5) — String
  • createdAt (Field6) — Date
  • modifiedAt (Field7) — Date