미용실 예약 프로젝트

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