qq

Tables (23)

chat_room

  • id — bigint — Primary key — NOT NULL
  • away_team — varchar(50)
  • created_at — datetime(6) — NOT NULL
  • double_header — bit(1) — NOT NULL
  • home_team — varchar(50)
  • name — varchar(100) — NOT NULL
  • room_key — varchar(100) — NOT NULL
  • start_at — datetime(6)
  • status — enum('ACTIVE','CANCELED','DRAFT') — NOT NULL

comment

  • id — bigint — Primary key — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • like_count — int — NOT NULL
  • member_id — bigint — NOT NULL
  • post_id — bigint — NOT NULL
  • updated_at — datetime(6) — NOT NULL

comment_like

  • id — bigint — Primary key — NOT NULL
  • comment_id — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • member_id — bigint — NOT NULL

escrow

  • id — bigint — Primary key — NOT NULL
  • amount — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • status — enum('CANCELLED','CONFIRMED','HOLD') — NOT NULL
  • buyer_id — bigint — Foreign key → member.member_id — NOT NULL
  • seller_id — bigint — Foreign key → member.member_id — NOT NULL
  • chatroom_id — bigint — Foreign key → useditem_chat_room.id — NOT NULL

follow

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • follower_id — bigint — NOT NULL
  • following_id — bigint — NOT NULL

game_info

  • id — bigint — Primary key — NOT NULL
  • crowd — varchar(255)
  • cs — varchar(255)
  • doublehit — varchar(255)
  • doubleout — varchar(255)
  • endtime — varchar(255)
  • err — varchar(255)
  • gametime — varchar(255)
  • gwrbi — varchar(255)
  • homerun — varchar(255)
  • matchcode — varchar(255) — NOT NULL
  • oob — varchar(255)
  • passedball — varchar(255)
  • pickoff — varchar(255)
  • referee — varchar(255)
  • sb — varchar(255)
  • stadium — varchar(255)
  • starttime — varchar(255)
  • triple — varchar(255)
  • wildpitch — varchar(255)

match_result

  • matchcode — varchar(20) — Primary key — NOT NULL

match_schedule

  • id — bigint — Primary key — NOT NULL
  • away — varchar(255)
  • dbheader — varchar(255)
  • gameid — varchar(255)
  • home — varchar(255)
  • match_date — date
  • match_status — varchar(255)
  • year — int

member

  • member_id — bigint — Primary key — NOT NULL
  • authority — enum('ADMIN','USER') — NOT NULL
  • bio — varchar(200)
  • created_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)
  • email — varchar(50) — NOT NULL
  • email_verified — bit(1) — NOT NULL
  • exp — bigint — NOT NULL
  • game_tag — bigint — NOT NULL
  • id — varchar(20) — NOT NULL
  • is_social — bit(1) — NOT NULL
  • kakao_id — varchar(255)
  • name — varchar(20) — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • pw — varchar(255) — NOT NULL
  • profile_image — text
  • team — varchar(20) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • wallet_address — varchar(42)

photo

  • id — bigint — Primary key — NOT NULL
  • content_type — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • file_url — varchar(255) — NOT NULL
  • s3key — varchar(255) — NOT NULL
  • member_id — bigint — Foreign key → member.member_id
  • post_id — bigint — Foreign key → useditem.post_id

point

  • point_id — bigint — Primary key — NOT NULL
  • balance — bigint — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL

point_transaction

  • transaction_id — bigint — Primary key — NOT NULL
  • amount — bigint
  • created_at — datetime(6)
  • type — varchar(50) — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • point_id — bigint — Foreign key → point.point_id — NOT NULL
  • toss_id — bigint — Foreign key → toss_payment.toss_id
  • balance_after — bigint
  • bank_name — varchar(255)
  • account_number — varchar(255)

post

  • id — bigint — Primary key — NOT NULL
  • caption — text
  • comment_count — int — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • like_count — int — NOT NULL
  • member_id — bigint — NOT NULL
  • updated_at — datetime(6) — NOT NULL

post_image

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • image_order — int — NOT NULL
  • image_url — varchar(255) — NOT NULL
  • post_id — bigint — NOT NULL

post_like

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • member_id — bigint — NOT NULL
  • post_id — bigint — NOT NULL

predicted

  • id — bigint — Primary key — NOT NULL
  • bat_amount — bigint
  • is_settled — int
  • payback_amount — bigint
  • predict — int
  • member_id — bigint — Foreign key → member.member_id
  • predicted_match_id — bigint — Foreign key → predicted_matches.id

predicted_matches

  • id — bigint — Primary key — NOT NULL
  • away — varchar(10)
  • away_amount — bigint
  • away_odds — double
  • home — varchar(10)
  • home_amount — bigint
  • home_odds — double
  • is_settled — int
  • result — int
  • match_id — bigint — Foreign key → match_schedule.id
  • ai_pick — int

scoreboard

  • id — bigint — Primary key — NOT NULL
  • audience — int
  • away — varchar(255)
  • balls — int
  • dbheader — varchar(255)
  • endtime — time(6)
  • err — int
  • gametime — varchar(255)
  • hit — int
  • home — varchar(255)
  • i_1 — int
  • i_10 — int
  • i_11 — int
  • i_12 — int
  • i_13 — int
  • i_14 — int
  • i_15 — int
  • i_16 — int
  • i_17 — int
  • i_18 — int
  • i_2 — int
  • i_3 — int
  • i_4 — int
  • i_5 — int
  • i_6 — int
  • i_7 — int
  • i_8 — int
  • i_9 — int
  • idx — bigint
  • matchcode — varchar(255) — NOT NULL
  • matchdate — date
  • matchday — varchar(255)
  • place — varchar(255)
  • result — varchar(255)
  • run — int
  • starttime — time(6)
  • team — varchar(255)

ticket

  • ticket_id — bigint — Primary key — NOT NULL
  • away_score — int
  • comment — varchar(15) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • date — date — NOT NULL
  • game — varchar(100) — NOT NULL
  • home_score — int
  • ipfs_image_hash — text
  • ipfs_metadata_hash — text
  • location — varchar(100) — NOT NULL
  • matchcode — varchar(255)
  • nft_metadata_uri — text
  • nft_minted — bit(1)
  • nft_minted_at — datetime(6)
  • nft_token_id — bigint
  • nft_transaction_hash — text
  • photo_url — text
  • review — text
  • seat — varchar(10) — NOT NULL
  • team — varchar(50)
  • type — varchar(50)
  • updated_at — datetime(6) — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL

toss_payment

  • toss_id — bigint — Primary key — NOT NULL
  • amount — bigint
  • approved_at — varchar(255)
  • failure — text
  • order_id — varchar(255)
  • payment_key — varchar(255)
  • status — varchar(255)
  • requested_at — datetime(6)
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • request_at — varchar(255)

useditem

  • post_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • description — varchar(1000) — NOT NULL
  • nickname — varchar(20)
  • price — int — NOT NULL
  • status — varchar(20)
  • team — enum('DOOSAN','HANWHA','KIA','KIWOOM','KT','LG','LOTTE','NC','SAMSUNG','SSG') — NOT NULL
  • title — varchar(50) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL

useditem_chat_room

  • id — bigint — Primary key — NOT NULL
  • buyer_id — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • room_key — varchar(100) — NOT NULL
  • seller_id — bigint — NOT NULL
  • status — enum('ACTIVE','CLOSED') — NOT NULL
  • useditem_id — bigint — Foreign key → useditem.post_id
  • seller_deleted — tinyint(1) — NOT NULL
  • buyer_deleted — tinyint(1) — NOT NULL
  • seller_unread_count — int — NOT NULL
  • buyer_unread_count — int — NOT NULL
  • last_message_at — datetime
  • last_message_content — varchar(500)

withdrawal

  • withdrawal_id — bigint — Primary key — NOT NULL
  • account_number — varchar(255)
  • amount — bigint
  • bank_name — varchar(255)
  • created_at — datetime(6)
  • deny_reason — varchar(255)
  • status — enum('APPROVED','COMPLETED','DENIED','REQUESTED')
  • updated_at — datetime(6)
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • bank — varchar(255)