mutsa13_hackathon

Tables (6)

article (Untitled3)

  • articleId (Key) — Bigint — Primary key — NOT NULL
  • title (Field) — Varchar(200)
  • content (Field2) — Text
  • userId (Key2) — Bigint — Foreign key → users.userId — NOT NULL

comment (Untitled6)

  • commentId (Key) — Bigint — Primary key — NOT NULL
  • comment (Field) — String
  • userId (Key2) — Bigint — Foreign key → users.userId — NOT NULL
  • articleId (Key3) — Bigint — Foreign key → article.articleId — NOT NULL

match (Untitled2)

  • matchId (Key2) — Bigint — Primary key — NOT NULL
  • cost (Field2) — Int
  • departure (Field6) — Varchar(50)
  • distance (Field) — Decimal
  • driver (Field3) — Varchar(50)
  • carNumber (Field4) — Varchar(50)
  • createdAt (Field5) — DateTime
  • requestId (Key3) — Bigint — Foreign key → matchRequeset.requestId — NOT NULL

matchRequeset (Untitled7)

  • requestId (Key) — Bigint — Primary key — NOT NULL
  • gender (Field) — Enum
  • age (Field2) — Enum
  • departure (Field3) — String
  • createdAt (Field4) — LocalDateTIme
  • withNum (Field5) — Int
  • destination (Field6)
  • userId (Key2) — Bigint — Foreign key → users.userId — NOT NULL

refreshToken (Untitled5)

  • tokenId (Key) — Bigint — Primary key — NOT NULL
  • token (Field2) — Text
  • email (Field3) — String

users (Untitled)

  • userId (Key) — Bigint — Primary key — NOT NULL
  • name (Field) — Varchar(50)
  • nickname (Field8) — Varchar(50)
  • gender (Field2) — Enum('MALE', 'FEMALE')
  • birth (Field3) — Date
  • rate (Field5) — Decimal
  • coin (Field6) — Int
  • email (Field7) — Varchar(100)
  • tokenId (Key3) — Bigint — Foreign key → refreshToken.tokenId — NOT NULL