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