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