미용실 예약 프로젝트
테이블 (10)
Blocks (스케줄 블록)
- id (Key) — 기본 키 — NOT NULL
- designer-key (Key2) — 외래 키 → Designers.designer-key — NOT NULL
- Reservation-key (Key3) — 외래 키 → Reservations.Reservation-key — NOT NULL
- date (Field)
- time (Field2)
- blockType (Field3) — ENUM
Designers (디자이너)
- designer-key (Key) — 기본 키 — NOT NULL
- shop-key (notnull) — 가게명 — 외래 키 → Shops.shop-key — NOT NULL
- name (Field) — VARCHAR(30)
- Introduction (Field2) — VARCHAR
- profile_image (Field6) — TEXT
- time_slot_list (Field5) — TEXT
- sns_uri_list (Field4) — TEXT
- created_at (Field7) — TIMESTAMP
- updated_at (Field8) — TIMESTAMP
- is_deleted (Field9) — boolean
- deleted_at (Field10) — TIMESTAMP
Favorites (좋아요)
- Key — 기본 키 — NOT NULL
- shop-key (Key2) — 외래 키 → Shops.shop-key — NOT NULL
- user-key (Key3) — 외래 키 → Users.user-key — NOT NULL
Reservations (예약)
- Reservation-key (Key) — 기본 키 — NOT NULL
- Service Menu-Key (Key3) — 외래 키 → Service Menu.Service Menu-Key — NOT NULL
- designer-key (Key2) — 외래 키 → Designers.designer-key — NOT NULL
- user-key (Key4) — 외래 키 → Users.user-key — NOT NULL
- date (Field2) — LOCAL DATA
- time (Field3) — LOCAL TIME
- 예약상태 (Field) — ENUM
Reviews (리뷰)
- Key — 기본 키 — NOT NULL
- Reservation-key (Key2) — 외래 키 → Reservations.Reservation-key — NOT NULL
- user-key (Key3) — 외래 키 → Users.user-key — NOT NULL
- title (Field)
- content (Field2)
- rating (Field3)
Service Menu (메뉴)
- Service Menu-Key (Key) — 기본 키 — NOT NULL
- designer-key (Key2) — 외래 키 → Designers.designer-key — NOT NULL
- category (Field4) — ENUM
- name (Field) — VARCHAR
- price (Field2) — INTEGER
- Introduction (Field3) — TEXT
- created_at (Field5) — TIMESTAMP
- updated_at (Field6) — TIMESTAMP
- is_deleted (Field7) — BOOLEAN
- deleted_at (Field8) — TIMESTAMP
Shop_tag (Untitled)
- shop_tag_key (Key) — 기본 키 — NOT NULL
- name (Field) — VARCHAR
- is_deleted (Field2) — BOOLEAN
Shops (가게)
- shop-key (Key) — 기본 키 — NOT NULL
- user-key (foregin-key) — 외래 키 → Users.user-key — NOT NULL
- name (Field) — VARCHAR(30)
- business _id (Field11) — VARCHAR
- address (Field2) — VARCHAR
- phone_number (Field3) — VARCHAR
- Introduction (Field7) — TEXT
- open_time (Field4) — TIMESTAMP
- end_time (Field5) — VARCHAR
- mainImage (Field6) — TEXT
- sns_uri _ list (Field10) — TEXT
- created_at (Field12) — TIMESTAMP
- updated_at (Field13) — TIMESTAMP
- deleted_at (Field14) — TIMESTAMP
- is_deleted (Field8) — BOOLEAN
- shop_status (Field9) — ENUM
- like_count (Field15) — INT
TagMappers (태그매퍼)
- 태그Key (Key) — 기본 키 — NOT NULL
- shop-key (Key3) — 외래 키 → Shops.shop-key — NOT NULL
- shop_tag_key (Key2) — 외래 키 → Shop_tag.shop_tag_key — NOT NULL
Users (사용자)
- user-key (Key) — 기본 키 — NOT NULL
- name (Field) — VARCHAR(15)
- email (Field3) — VARCHAR(30)
- password (Field2) — VARCHAR(30)
- phone_number (Field10) — VARCHAR(13)
- gender (Field4) — ENUM
- user_role (Field5) — ENUM
- profile_image (Field11) — TEXT
- created_at (Field6) — TIMESTAMP
- updated_at (Field7) — TIMESTAMP
- deleted_at (Field8) — TIMESTAMP
- is_deleted (Field9) — BOOLEAN