gamzabit
Tables (16)
Commission (거래 수수료율)
- id (Key) — INT — Primary key — NOT NULL
- commission_rate (Field) — NUMBER
- created_at (Field2) — DATETIME
- updated_at (Field3) — DATETIME
Order (유저 주문)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.id — NOT NULL
- asset_id (Field) — INT
- orderQuantity (Field2) — NUMBER
- orderPrice (Field3) — INT
- orderType (Field4) — VARCHAR
- orderState (Field5) — VARCHAR
- order_at (Field6) — DATETIME
OrderTransaction (주문 거래)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- asset_id (Field3) — INT
- concludedQuantity (Field2) — NUMBER
- concludedKrw (Field4) — NUMBER
- created_at (Field5) — TIMESTAMP
Symbol (가상화폐)
- id (Key) — INT — Primary key — NOT NULL
- symbolName (Field) — VARCHAR
- delisting (Field2) — BOOL
- currentValue (Field3)
SymbolBookmark (가상화폐 즐겨찾기)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.id — NOT NULL
- symbol_id (Key3) — INT — Foreign key → Symbol.id — NOT NULL
ThreadComment (유저 스레드 댓글)
- id (Key) — INT — Primary key — NOT NULL
- thread_id (Key2) — INT — Foreign key → UserThread.id — NOT NULL
- content (Field) — VARCHAR
- created-at (Field2) — TIMESTAMP
ThreadReaction (스레드 반응)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- thread_id (Field2) — INT
- reaction (Field3) — TINYINT
- created_at (Field4) — DATETIME
ThreadVote (유저 스레드 투표)
- id (Key) — INT — Primary key — NOT NULL
- thread_id (Key2) — INT — Foreign key → UserThread.id — NOT NULL
- vote_title (Field) — VARCHAR
- created_at (Field2) — DATETIME
ThreadVoteItem (투표 목록)
- id (Key) — INT — Primary key — NOT NULL
- title (Field) — VARCHAR
- id (Key2) — INT — Foreign key → ThreadVote.id — NOT NULL
User (거래소 회원)
- id (Key) — INT — Primary key — NOT NULL
- nickname (닉네임) — VARCHAR
- email (아이디) — VARCHAR
- password (패스워드) — VARCHAR
- created_at (가입일) — DATETIME
- deleted (회원탈퇴 여부) — TINYINT
- deleted_at (회원탈퇴 날짜) — DATETIME
UserAsset (유저 자산)
- id (Key) — INT — Primary key — NOT NULL
- amount (Field3) — INT
- user_id (Key2) — INT — Foreign key → User.id — NOT NULL
- symbol_id (Key3) — INT — Foreign key → Symbol.id — NOT NULL
UserAssetTransaction (유저 자산 입출금)
- id (Key) — INT — Primary key — NOT NULL
- amount (Field) — INT
- tx_date (Field2) — DATETIME
- tx_type (Field3) — VARCHAR
- destination_address (Field4) — VARCHAR
- user_id (Key2) — Foreign key → User.id — NOT NULL
- asset_id (Key3) — INT — Foreign key → UserAsset.id — NOT NULL
UserFreezeAsset (유저 동결 자산)
- id (Key) — INT — Primary key — NOT NULL
- amount (Field) — INT
- tx_date (Field2) — DATETIME
- user_id (Field3) — INT
- asset_id (Field4) — INT
- order_id (Field5) — INT
UserRevenue (날짜별 유저 수익)
- id (Key) — INT — Primary key — NOT NULL
- created_at (Field) — DATETIME
- totalPurchasePrice (Field2) — INT
- totalEvaluationPrice (Field3) — INT
- totalProfit (Field4) — INT
- totalRevenueRate (Field5) — NUMBER
- user_id (Field6)
UserThread (유저 스레드 게시글)
- id (Key) — INT — Primary key — NOT NULL
- shared_id (Field) — UUID
- content (Field2) — VARCHAR (150)
- user_id (Field3) — INT
- created_at (Field4) — DATETIME
- deleted (Field5) — TINYINT
UserVote (유저 투표)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- vote_item_id (Field2) — INT