snapcall-db

Tables (11)

Category (category)

  • id (Key) — bigint — Primary key — NOT NULL
  • category_name (Field) — varchar(15)

Photographer (photographer)

  • id (Key) — bigint — Primary key — NOT NULL
  • photographer_name (Field) — varchar(20)
  • location (Field2) — varchar(30)
  • time (Field3) — varchar(336)
  • main_photo_key (Field4) — varchar(50)

PortfolioPhoto (portfolio_photo)

  • id (Key) — bigint — Primary key — NOT NULL
  • photographer_id (FK1) — bigint — Foreign key → Photographer.id — NOT NULL
  • index (Field) — integer
  • storage_key (Field2) — varchar(50)
  • text (Field3) — varchar(50)

Product (product)

  • id (Key) — bigint — Primary key — NOT NULL
  • photographer_id (FK1) — bigint — Foreign key → Photographer.id — NOT NULL
  • category_id (FK2) — bigint — Foreign key → Category.id — NOT NULL
  • product_name (Field) — varchar(30)
  • price (Field2) — integer
  • duration (Field3) — integer

ProductTag (product_tag)

  • id (Key) — bigint — Primary key — NOT NULL
  • product_id (FK1) — bigint — Foreign key → Product.id — NOT NULL
  • tag_id (FK2) — bigint — Foreign key → Tag.id — NOT NULL

QnA (qna)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK1) — bigint — Foreign key → User.id — NOT NULL
  • photographer_id (FK2) — bigint — Foreign key → Photographer.id — NOT NULL
  • title (Field) — varchar(100)
  • content (Field2) — varchar(1000)
  • answer (Field3) — varchar(1000)

Reservation (reservation)

  • id (Key) — bigint — Primary key — NOT NULL
  • product_id (FK1) — bigint — Foreign key → Product.id — NOT NULL
  • user_id (FK2) — bigint — Foreign key → User.id — NOT NULL
  • date (Field) — Date
  • time (Field2) — integer
  • is_accepted (Field3) — boolean

Review (review)

  • id (Key) — bigint — Primary key — NOT NULL
  • reservation_id (FK1) — bigint — Foreign key → Reservation.id — NOT NULL
  • stars (Field) — integer
  • content (Field2) — varchar(500)
  • photo_key (Field3) — varchar(50)

Scrap (scrap)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK1) — bigint — Foreign key → User.id — NOT NULL
  • photographer_id (FK2) — bigint — Foreign key → Photographer.id — NOT NULL

Tag (tag)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Filed1) — varchar(20)

User (user)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_name (Field) — varchar(50)
  • email (Field2) — varchar(50)
  • phone_number (Field3) — varchar(15)
  • kakao_id (Field4) — varchar(40)