우법

테이블 (8)

Case

  • id — int — 기본 키 — NOT NULL
  • authorId — int — 외래 키 → Client.id — NOT NULL
  • title — varchar(191) — NOT NULL
  • content — varchar(191) — NOT NULL

Cases_Categories

  • caseId — int — 외래 키 → Case.id — NOT NULL
  • categoryId — int — 외래 키 → Category.id — NOT NULL

Category

  • id — int — 기본 키 — NOT NULL
  • name — varchar(191) — NOT NULL
  • parentId — int

Client

  • id — int — 기본 키 — NOT NULL
  • email — varchar(191) — NOT NULL
  • password — varchar(191) — NOT NULL
  • name — varchar(191) — NOT NULL
  • birthday — varchar(191) — NOT NULL
  • sex — varchar(191) — NOT NULL
  • phoneNumber — varchar(191) — NOT NULL
  • address — varchar(191) — NOT NULL
  • description — varchar(191)
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp — NOT NULL

Company

  • id — int — 기본 키 — NOT NULL
  • email — varchar(191) — NOT NULL
  • password — varchar(191) — NOT NULL
  • name — varchar(191) — NOT NULL
  • description — varchar(191) — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp — NOT NULL

Lawyer

  • id — int — 기본 키 — NOT NULL
  • companyId — int — 외래 키 → Company.id — NOT NULL
  • name — varchar(191) — NOT NULL
  • description — varchar(191) — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp — NOT NULL

Reservation

  • id — int — 기본 키 — NOT NULL
  • clientId — int — 외래 키 → Client.id — NOT NULL
  • categoryId — int — 외래 키 → Category.id — NOT NULL
  • lawyerId — int — 외래 키 → Lawyer.id — NOT NULL
  • companyId — int — 외래 키 → Lawyer.companyId — NOT NULL
  • title — varchar(191) — NOT NULL
  • content — varchar(191) — NOT NULL
  • status — char(1) — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp — NOT NULL

_prisma_migrations

  • id — varchar(36) — 기본 키 — NOT NULL
  • checksum — varchar(64) — NOT NULL
  • finished_at — datetime(3)
  • migration_name — varchar(255) — NOT NULL
  • logs — text
  • rolled_back_at — datetime(3)
  • started_at — datetime(3) — NOT NULL
  • applied_steps_count — int — NOT NULL