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