KimsHairStudio

Tables (4)

Member (회원)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(50)
  • birth_date (생년월일) — DATE
  • email (이메일) — VARCHAR(200)
  • password (비밀번호) — VARCHAR(255)
  • created_at (생성일시) — DATETIME
  • updated_at (수정일시) — DATETIME
  • deleted_at (탈퇴일시) — DATETIME
  • role (권한) — VARCHAR(30)

Payment (결제)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • Field

Reservation (예약)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • member_id (멤버 아이디) — BIGINT — Foreign key → Member.id — NOT NULL
  • service_id (서비스 아이디) — BIGINT — Foreign key → Service.id — NOT NULL
  • memo (메모) — TEXT
  • created_at (생성일시) — DATETIME
  • updated_at (수정일시) — DATETIME
  • status (상태) — VARCHAR(30)

Service (Untitled)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(255)
  • price (가격) — INT
  • duration_minutes (소요 시간) — INT
  • description (설명) — TEXT
  • created_at (생성일시) — DATETIME
  • updated_at (수정일시) — DATETIME
  • active (활성 여부) — BOOLEAN