다짐

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