Carrot - clone

Tables (6)

Article (게시글)

  • article_id (Key) — bigint — Primary key — NOT NULL
  • category_id (Key2) — bigint — Foreign key → Category.category_id — NOT NULL
  • brand_id (Key3) — bigint — Foreign key → Brand.brand_id — NOT NULL
  • created_at (Field) — DATETIME(6)
  • updated_at (Field2) — DATETIME(6)
  • title (Field3) — VARCHAR(30)
  • like_count (Field4) — bigint
  • view_count (Field5) — bigint

Article_Url (게시글 사진)

  • id (Key) — bigint — Primary key — NOT NULL
  • article_id (Key2) — bigint — Foreign key → Article.article_id — NOT NULL
  • category_id (Key22) — bigint — Foreign key → Article.category_id — NOT NULL
  • brand_id (Key3) — bigint — Foreign key → Article.brand_id — NOT NULL
  • imgUrl (Field) — VARCHAR(100)

Brand (브랜드)

  • brand_id (Key) — bigint — Primary key — NOT NULL
  • title (Field) — VARCHAR(10)

Category (카테고리)

  • category_id (Key) — bigint — Primary key — NOT NULL
  • title (Field) — VARCHAR(10)

Review (리뷰)

  • review_id (PK) — bigint — Primary key — NOT NULL
  • content (Field) — VARCHAR(100)

User (사용자)

  • user_id (Key) — bigint — Primary key — NOT NULL
  • created_at (Field) — DATETIME(6)
  • updated_at (Field2) — DATETIME(6)
  • category_id (Field3) — bigint
  • nickname (Field4) — VARCHAR(10)
  • mannerPoint (Field5) — bigint