인쇄골목

테이블 (7)

OrderPhotos

  • PhotoID — INT
  • OrderID — INT
  • PhotoURL — VARCHAR(255) — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • isDeleted — BOOLEAN

Orders

  • OrderID — INT
  • UserID — INT
  • ShopID — INT
  • OrderDetails — TEXT — NOT NULL
  • OrderStatus — ENUM('Placed', 'In Progress', 'Completed', 'Cancelled')
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • isDeleted — BOOLEAN

PrintShops

  • ShopID — INT
  • Name — VARCHAR(255) — NOT NULL
  • Description — TEXT
  • Location — VARCHAR(255)
  • Rating — FLOAT
  • TotalReviews — INT
  • Category — VARCHAR(255) — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • isDeleted — BOOLEAN

ReviewPhotos

  • PhotoID — INT
  • ReviewID — INT
  • PhotoURL — VARCHAR(255) — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • isDeleted — BOOLEAN

Reviews

  • ReviewID — INT
  • UserID — INT
  • ShopID — INT
  • Rating — FLOAT — NOT NULL
  • Comment — TEXT — EX
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • isDeleted — BOOLEAN

UserFavorites

  • FavoriteID — INT
  • UserID — INT
  • ShopID — INT
  • createdAt — TIMESTAMP

Users

  • UserID — INT
  • Username — VARCHAR(255) — NOT NULL
  • Email — VARCHAR(255) — NOT NULL
  • PasswordHash — VARCHAR(255) — NOT NULL
  • SocialLoginType — ENUM('Google', 'Facebook', 'Kakao', 'None')
  • ProfilePictureURL — VARCHAR(255)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • isDeleted — BOOLEAN