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