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