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