be-simple

Tables (6)

Copy Of schedules (CopyOfschedules)

  • id — INTEGER(11) — Primary key — NOT NULL
  • partnerId — INTEGER(11) — Foreign key → partnerDetails.id — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • day — ENUM('mon','tue','wed',...)
  • time — TIME

Reservation

  • id — INTEGER(11) — Primary key — NOT NULL
  • userId — INTEGER(11) — Foreign key → userDetails.id — NOT NULL
  • partnerId — INTEGER(11) — Foreign key → partnerDetails.id — NOT NULL
  • startAt — DATETIME
  • isend (endAt) — DATETIME
  • roomId — MEDIUMTEXT
  • note — VARCHAR(300)

partnerDetails

  • id — INTEGER(11) — Primary key — NOT NULL
  • partnerId — INTEGER(11) — Foreign key → users.id — NOT NULL
  • name — VARCHAR(255)
  • gender — TINYINT
  • age — TINYINT
  • phoneNumber — VARCHAR(255)
  • url — VARCHAR(255)
  • shortInfo (Field) — VARCHAR(255)
  • career — TEXT
  • info — TEXT
  • chatCost — INTEGER
  • keyword — VARCHAR(255)
  • Field2

schedules

  • id — INTEGER(11) — Primary key — NOT NULL
  • userId — INTEGER(11) — Foreign key → userDetails.id — NOT NULL
  • partnerId — INTEGER(11) — Foreign key → partnerDetails.id — NOT NULL
  • roomId — MEDIUMTEXT
  • startedAt — DATETIME
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • note — VARCHAR(300)

userDetails

  • id — INTEGER(11) — Primary key — NOT NULL
  • userId — INTEGER(11) — Foreign key → users.id — NOT NULL
  • name — VARCHAR(20)
  • gender — TINYINT(1)
  • age — TINYINT(1)
  • createdAt — DATETIME
  • updatedAt — DATETIME

users

  • id — INTEGER(11) — Primary key — NOT NULL
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • type — TINYINT
  • createdAt — DATETIME
  • updatedAt — DATETIME