BE-SIMPLE

Tables (9)

keywords

  • id — BIGINT(11) — Primary key — NOT NULL
  • userId — INTEGER(11)
  • name — VARCHAR(255)
  • createdAt — DATETIME
  • updatedAt — DATETIME

logs

  • id — BIGINT(13) — Primary key — NOT NULL
  • type — VARCHAR(25)
  • history — TEXT
  • createdAt — DATETIME
  • updatedAt — DATETIME

messages

  • id — BIGINT(13) — Primary key — NOT NULL
  • user — INTEGER(11)
  • content — TEXT
  • createdAt — DATETIME
  • updatedAt — DATETIME

partnerDetails

  • id — INTEGER(11) — Primary key — NOT NULL
  • parnerId (partnerId) — INTEGER(11) — Foreign key → users.id — NOT NULL
  • name — VARCHAR(20)
  • gender — TINYINT(1)
  • age — TINYINT(1)
  • phoneNumber (Field) — VARCHAR(20)
  • url — VARCHAR(255)
  • shortInfo — VARCHAR(255)
  • career — TEXT
  • info — TEXT
  • chatCost — INT(11)
  • keyword — VARCHAR(255)
  • level — TINYINT(1)
  • certificate — TINYINT
  • image — VARCHAR(255)
  • evaluate — BOOLEAN
  • createdAt — DATETIME
  • updatedAt — DATETIME

points

  • id — BIGINT(11) — Primary key — NOT NULL
  • userId — INTEGER(11) — Foreign key → userDetails.userId — NOT NULL
  • point — BIGINT(13)
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • Field — VARCHAR(255)

schedules

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

tokens

  • id — BIGINT(13) — Primary key — NOT NULL
  • userId — INTEGER(11)
  • accessToken — VARCHAR(255)
  • refreshToken — VARCHAR(255)
  • createdAt — DATETIME
  • updatedAt — DATETIME

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(24)
  • password — VARCHAR(255)
  • type — TINYINT
  • createdAt — DATETIME
  • updatedAt — DATETIME