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)