코인끼리 ERD

테이블 (4)

관심 코인 (Interest)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • membe_id (FK1) — bigint — 외래 키 → 유저.id — NOT NULL
  • market (FK2) — String — 외래 키 → 코인.market — NOT NULL

유저 (Member)

  • id (PK) — bigint — 기본 키 — NOT NULL
  • socialId (Field1) — String
  • socialType (Field2) — String
  • nickname (Field3) — String
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

채팅 (Chat)

  • market (PK2) — String — 외래 키 → 코인.market — NOT NULL
  • member_id (Field1) — bigint
  • nickname (Field2) — String
  • created_at (Field3) — timestamp

코인 (Coin)

  • market (PK) — String — 기본 키 — NOT NULL
  • korean_name (Field1) — String
  • english_name (Field2) — String
  • symbol (Field3) — ByteArray
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp