상담

테이블 (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