상담
테이블 (15)
chats
- id — BIGINT(13) — 기본 키 — NOT NULL
- type — TINYINT(1)
- message — VARCHAR(255)
- createdAt — DATETIME
- req_id (Field)
- resp_id (Field2)
doctor_details
- id — BIGINT(11) — 기본 키 — NOT NULL
- doctorId — BIGINT(13) — 외래 키 → doctors.id — NOT NULL
- introduce — TEXT
- info — TEXT
- level — TINYINT(1)
- gender — TINYINT(1)
- keywords — VARCHAR(255)
- certificate — TIMYINT(1)
- createdAt — DATETIME
- updatedAt — DATETIME
doctors
- id — BIGINT(11) — 기본 키 — NOT NULL
- email — VARCHAR(24)
- password — VARCHAR(255)
- salt — BIGINT(13)
- isDeleted — TINYINT(1)
- createdAt — DATETIME
- updatedAt — DATETIME
keywords (3)
- id — BIGINT(11) — 기본 키 — NOT NULL
- keyword — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
keywords
- id — BIGINT(11) — 기본 키 — NOT NULL
- name — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
logs
- id — BIGINT(13) — 기본 키 — NOT NULL
- type — VARCHAR(25)
- history — TEXT
- Field
partnerDetails
- id — INTEGER(11) — 기본 키 — NOT NULL
- partnerId — INTEGER(11) — 외래 키 → users.id — NOT NULL
- name — VARCHAR(20)
- gender — TINYINT(1)
- age — TINYINT(1)
- address — VARCHAR(255)
- url — VARCHAR(255)
- shortInfo — VARCHAR(255)
- career — TEXT
- info — TEXT
- chatCost — INT(11)
- keyword — VARCHAR(255)
- level — TINYINT(1)
- latitude — float
- longitude — float
- image — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
points
- id — BIGINT(11) — 기본 키 — NOT NULL
- userId — INTEGER(11) — 외래 키 → userDetails.userId — NOT NULL
- point — BIGINT(13)
- createdAt — DATETIME
- updatedAt — DATETIME
- Field
schedules (2)
- id — BIGINT(13) — 기본 키 — NOT NULL
- doctorId — BIGINT(13) — 외래 키 → doctors.id — NOT NULL
- start_at — TIMESTAMP
- createdAt — DATETIME
- updatedAt — DATETIME
- user_id — BIGINT(11)
- Field
schedules
- id — INTEGER(11) — 기본 키 — NOT NULL
- userId — INTEGER(11) — 외래 키 → userDetails.userId — NOT NULL
- partnerId — INTEGER(11) — 외래 키 → partnerDetails.partnerId — NOT NULL
- startedAt — DATETIME
- createdAt — DATETIME
- updatedAt — DATETIME
- Field
tokens
- id — INT(11) — 기본 키 — NOT NULL
- access_token — VARCHAR(255)
- refresh_token — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
userDetails
- id — INTEGER(11) — 기본 키 — NOT NULL
- userId — INTEGER(11) — 외래 키 → users.id — NOT NULL
- name — VARCHAR(20)
- gender — TINYINT(1)
- age — TINYINT(1)
- createdAt — DATETIME
- updatedAt — DATETIME
user_details
- id — BIGINT(11) — 기본 키 — NOT NULL
- userId — BIGINT(11) — 외래 키 → users.id — NOT NULL
- name — VARCHAR(20)
- phone — VARCHAR(20)
- gender — TINYINT
- createdAt — DATETIME
- updatedAt — DATETIME
users (1)
- id — BIGINT(11) — 기본 키 — NOT NULL
- email — VARCHAR(24)
- password — VARCHAR(255)
- salt — BIGINT(13)
- IsDeleted (isDeleted) — TINYINT(1)
- createdAt — DATETIME
- updatedAt — DATETIME
users
- id — INTEGER(11) — 기본 키 — NOT NULL
- email — VARCHAR(24)
- password — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME