qrqrqr
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
- account_number — varchar(255)
- amount — bigint
- balance_after — bigint
- bank_name — varchar(255)
- created_at — datetime(6)
- type — enum('CHARGE','ESCROW_CANCEL','ESCROW_CONFIRMED','ESCROW_DEPOSIT','WITHDRAW') — 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
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
- ai_pick — int
- 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
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(200) — 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(50) — 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 — enum('CANCELLED','CONFIRMED','HOLD')
- 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_deleted — bit(1) — NOT NULL
- buyer_id — bigint — NOT NULL
- buyer_unread_count — int — NOT NULL
- created_at — datetime(6) — NOT NULL
- last_message_at — datetime(6)
- last_message_content — varchar(500)
- room_key — varchar(100) — NOT NULL
- seller_deleted — bit(1) — NOT NULL
- seller_id — bigint — NOT NULL
- seller_unread_count — int — NOT NULL
- status — enum('ACTIVE','CLOSED') — NOT NULL
- useditem_id — bigint — Foreign key → useditem.post_id
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