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