코인끼리 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