dasii
Tables (12)
BigCategory (Untitled7)
- id (pk) — Primary key — NOT NULL
- category (카테고리) — string
Ingredients (Untitled5)
- id (pk) — Primary key — NOT NULL
- name (성분 이름) — string
- minRecommended (최소권장량) — int
- effect (효과) — string
- sideEffect (부작용) — string
- englishIngredient (영어이름) — string
- maxRecomended (최대권장량) — int
SmallCategory (Untitled8)
- id (pk) — Primary key — NOT NULL
- bigcategoryId (대분류 외래키) — Foreign key → BigCategory.id — NOT NULL
- category (카테고리) — string
categoryProduct (Untitled9)
- id (pk) — Primary key — NOT NULL
- categoryId (카테고리 외래키) — Foreign key → SmallCategory.id — NOT NULL
- productId (제품 외래키) — Foreign key → products.id — NOT NULL
productImages (Untitled11)
- id (pk) — Primary key — NOT NULL
- url — string
- productId (제품아이디) — Foreign key → products.id — NOT NULL
productIngredients (Untitled4)
- id (pk) — Primary key — NOT NULL
- productId (제품 외래키) — Foreign key → products.id — NOT NULL
- ingredientId (성분 외래키) — Foreign key → Ingredients.id — NOT NULL
- amount (포함량) — int
products (Untitled2)
- id (pk) — Primary key — NOT NULL
- name (제품이름) — string
- company (회사이름) — string
- price (가격) — int
- unit (단위) — string
- piece (개수) — int
- nutrients (영양정보) — string
- viewCount (조회수) — int
ranking (Untitled3)
- id (pk) — Primary key — NOT NULL
- category (카테고리)
- productId (제품 아이디) — Foreign key → products.id — NOT NULL
- order (순서) — int
refreshToken (Untitled12)
- id (pk) — Primary key — NOT NULL
- userId (유저아이디) — Foreign key → users.id — NOT NULL
- refreshToken (리프레시 토큰)
reviewImages (Untitled10)
- id (pk) — Primary key — NOT NULL
- url — string
- reviewId (리뷰 아이디) — Foreign key → reviews.id — NOT NULL
reviews (Untitled6)
- id (Key) — Primary key — NOT NULL
- userId (유저 아이디) — Foreign key → users.id — NOT NULL
- rate (별점) — int
- review (리뷰) — string
- date (최종날짜) — Date()
- productId (프로덕트 아이디) — Foreign key → products.id — NOT NULL
users (Untitled)
- id (pk) — Primary key — NOT NULL
- nickname (닉네임) — string
- email (이메일) — string
- password (비밀번호) — string
- kakdo (카카오) — boolean
- google (구글) — boolean
- apple (애플) — boolean
- phoneNumber (전화번호) — string