f12

Tables (5)

following (팔로잉)

  • id — Primary key — NOT NULL
  • 팔로우 대상 id (following_id) — Foreign key → member.id — NOT NULL
  • 팔로워 id (follower_id) — Foreign key → member.id — NOT NULL

inventory_product (인벤토리 장비)

  • id — Primary key — NOT NULL
  • 제품 id (product_id) — Foreign key → product.id — NOT NULL
  • 소유자 id (member_id) — Foreign key → member.id — NOT NULL

member (회원)

  • id — Primary key — NOT NULL
  • GitHub id (github_id)

product (제품(장비))

  • id — Primary key — NOT NULL
  • 이름 (name)

review (리뷰)

  • id — Primary key — NOT NULL
  • 작성자 id (member_id) — Foreign key → member.id — NOT NULL
  • 리뷰 대상 id (product_id) — Foreign key → product.id — NOT NULL
  • 평점 (rating)