다짐
테이블 (5)
admin
- id — INT — 기본 키 — NOT NULL
- email — VARCHAR
- phone — CHAR(20)
- created_at — DATETIME
- updated_at (create_at) — DATETIME
- deleted_at — DATETIME
- id (id2) — VARCHAR — 외래 키 → centers.id — NOT NULL
- uid — UUID — 외래 키 → centers.uid — NOT NULL
centers
- id — VARCHAR — 기본 키 — NOT NULL
- uid — UUID — 외래 키 → users.uid — NOT NULL
- cid — INT
- name — VARCHAR
- create_at — DATETIME
- deleted_at (delted_at) — DATETIME
- location — VARCHAR
reviews
- id — INT — 기본 키 — NOT NULL
- scroe (scrore) — INT
- Field
- created_at — DATETIME
- updated_at — DATE_TIME
- uid — UUID — 외래 키 → users.uid — NOT NULL
- id (id2) — VARCHAR — 외래 키 → centers.id — NOT NULL
services
- id — INT — 기본 키 — NOT NULL
- uid — UUID — 외래 키 → users.uid — NOT NULL
- id (id2) — VARCHAR — 외래 키 → centers.id — NOT NULL
- service — VARCHAR
users
- uid — UUID — 기본 키 — NOT NULL
- password — VARCHAR — NOT NULL
- email — VARCHAR — NOT NULL
- phone — CHAR(20) — NOT NULL
- name — CHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME