ourtube

테이블 (44)

app_push 개인이 받은 푸시 알람 리스트 (app_push)

  • app_push_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • is_see — tinyint(4) — NOT NULL
  • data (메시지) — varchar(3000) — NOT NULL
  • user_id — int(11) — 외래 키 → users.user_id — NOT NULL
  • app_push_mold_id — varchar(255) — 외래 키 → app_push_mold 푸시 알람 템플릿.app_push_mold_id — NOT NULL

app_push_channel 채널 구독정보 (app_push_channel)

  • app_push_channel_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • fcm_id — int(11) — 외래 키 → fcm_token 파이어베이스 메시지 토큰.fcm_id — NOT NULL
  • channel_id — varchar(255) — 외래 키 → channels (유튜브 채널).channel_id — NOT NULL

app_push_mold 푸시 알람 템플릿 (app_push_mold)

  • app_push_mold_id — varchar(255) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • push_type (?) — varchar(255)
  • title (템플릿 타이틀) — varchar(100) — NOT NULL
  • body (템플릿 바디) — varchar(500) — NOT NULL
  • depp_link (메시지 클릭하면 특정 화면으로 이동하기위한 링크) — varchar(1000)

auction_history 옥션의 모든 행위 이력 (auction_history)

  • auction_history_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • wallet_id — char(36) — 외래 키 → wallets.wallet_id
  • auction_id — char(36) — 외래 키 → auctions.auction_id
  • bid_cash — int(11) — NOT NULL
  • target_count (주문 수량) — int(11) — NOT NULL
  • succeed_count (체결된 수량) — int(11) — NOT NULL
  • auction_history_status (행위) — enum('bid','rebid','cancel','fail_bid','success_bid','success_part_bid') — NOT NULL

auction_rule_list

  • auction_rule_list_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • rule — varchar(255) — NOT NULL
  • auction_rule_id — int(11) — 외래 키 → auction_rules.auction_rule_id — NOT NULL

auction_rules

  • auction_rule_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • rule_title — varchar(255) — NOT NULL

auctions

  • auction_id — char(36) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • bid_cash — int(11) — NOT NULL
  • bid_count — int(11) — NOT NULL
  • auction_status — enum('fail_bid','in_progress','success_part_bid','success_bid','cancel') — NOT NULL
  • user_id — int(11) — 외래 키 → users.user_id
  • channel_auction_id — int(11) — 외래 키 → channel_auction.channel_auction_id

bank

  • bank_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • logo — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • code — varchar(255) — NOT NULL

banner_details

  • image_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • banner_id — int(11) — NOT NULL
  • image_url — varchar(2000) — NOT NULL

banners

  • banner_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • image_url — varchar(2000) — NOT NULL
  • banner_type — varchar(50) — NOT NULL

blacklist

  • id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • user_id — int(11)
  • unique_key — varchar(255)
  • uid_kakao — varchar(255)
  • uid_apple — varchar(255)

buy_orders 구매 주문 (buy_orders)

  • buy_order_id — char(36) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • order_quantity (주문 수량) — int(11) — NOT NULL
  • traded_quantity (체결된 수량 (계속 업데이트 됨)) — int(11) — NOT NULL
  • order_status — enum('ongoing','closed','cancel') — NOT NULL
  • order_price (주문 단가 (order_unit_price로 변경?)) — int(11) — NOT NULL
  • user_id — int(11) — 외래 키 → users.user_id — NOT NULL
  • channel_id — varchar(255) — 외래 키 → channels (유튜브 채널).channel_id

channel_auction

  • channel_auction_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • auction_start_datetime — datetime — NOT NULL
  • auction_end_datetime — datetime — NOT NULL
  • auction_count — int(11) — NOT NULL
  • start_price — int(11) — NOT NULL
  • auction_status — enum('expected','inProgress','closed') — NOT NULL
  • channel_id — varchar(255) — 외래 키 → channels (유튜브 채널).channel_id — NOT NULL
  • remained_count (옥션 종료 후 남은 개수) — int(11) — NOT NULL
  • total_sales_revenue (낙찰 평균가) — int(10) — NOT NULL
  • Field

channel_images

  • channel_image_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • image_url — varchar(255) — NOT NULL
  • image_type — varchar(255) — NOT NULL
  • channel_id — varchar(255) — 외래 키 → channels (유튜브 채널).channel_id — NOT NULL

channel_profit_of_ad 채널 광고 수익금 내역 (channel_profit_of_ad)

  • id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • profit — int(10) — NOT NULL
  • circulating_supply (광고수익금 발생일 당시의 유통량) — int(11) — NOT NULL
  • copyright_fee_firstday (광고수익금 해당 월의 1일) — date — NOT NULL
  • copyright_fee_lastday (광고수익금 해당 월의 말일) — date — NOT NULL
  • holding_snapshots_schedule (보유 지분 스냅샷 예정일) — datetime — NOT NULL
  • share_schedule (광고수익금 분배 예정일) — datetime — NOT NULL
  • sharedAt (광고수익금 분배된 날짜 (분배시 등록됨)) — datetime
  • channel_id — varchar(255) — 외래 키 → channels (유튜브 채널).channel_id — NOT NULL

channel_videos

  • channel_video_id — varchar(255) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • published_at — varchar(255) — NOT NULL
  • duration — varchar(50) — NOT NULL
  • videoTitle — varchar(1000) — NOT NULL
  • videoThumbnailUrl — varchar(2000) — NOT NULL
  • view_count — int(10)
  • video_type — enum('normal','popular') — NOT NULL
  • channel_id — varchar(255) — 외래 키 → channels (유튜브 채널).channel_id — NOT NULL

channels (유튜브 채널) (channels)

  • channel_id — varchar(255) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • publishedAt (옥션 분배 예정 날짜) — varchar(255) — NOT NULL
  • channel_title — varchar(300) — NOT NULL
  • subscriber_count — int(10) — NOT NULL
  • logo_image — varchar(2000) — NOT NULL
  • main_thumbnail — varchar(3000) — NOT NULL
  • description — varchar(3000)
  • view_count — int(11)
  • hidden_subscriber_count — tinyint(4) — NOT NULL
  • circulating_supply (유통량) — int(11) — NOT NULL
  • max_supply (발행량) — int(11) — NOT NULL
  • holding_snapshot_day (보유 지분 스냅샷 예정일) — varchar(255) — NOT NULL
  • holding_snapshot_time (보유 지분 스냅샷 예정시간) — varchar(255) — NOT NULL
  • share_day (옥션 분배 예정일) — varchar(255) — NOT NULL
  • channel_status (옥션 진행중, 등의 상태 표시) — enum('expected_auction','in_progress_auction','closed_auction_with_trade','in_progress_trade_with_auction','closed_trade','abolition_trade') — NOT NULL
  • partner_id — int(11) — 외래 키 → partners 아직 미사용\.partner_id

companies

  • id — int(11) — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • account_bank_name — varchar(255) — NOT NULL
  • account_number — varchar(255) — NOT NULL
  • account_owner_name — varchar(255) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

event_first_charge 회원가입 첫 충전 이벤트 (event_first_charge)

  • id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • point — int(11) — NOT NULL
  • user_id — int(11) — 외래 키 → users.user_id — NOT NULL

event_sign_up 회원가입 이벤트 테이블 (event_sign_up)

  • id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • point — int(11) — NOT NULL
  • user_id — int(11) — 외래 키 → users.user_id — NOT NULL

events 친구초대 이벤트 테이블 (events)

  • event_pair_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • participant_id — int(11) — NOT NULL
  • recommender_id — int(11) — NOT NULL
  • participant_wallet_history_id — int(11) — NOT NULL
  • recommender_wallet_history_id — int(11) — NOT NULL

exchange_history 입출금 내역 (exchange_history)

  • exchange_history_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • type — enum('withdrawal','deposit') — NOT NULL
  • status (모든 행위가 기록으로 남음) — enum('waiting','done','cancel') — NOT NULL
  • variable_amount (거래 금액 (수수료 제외)) — int(11) — NOT NULL
  • fee — int(11) — NOT NULL
  • balance (잔고) — int(11) — NOT NULL
  • description — varchar(255) — NOT NULL
  • description_additional — varchar(255) — NOT NULL
  • wallet_id — char(36) — 외래 키 → wallets.wallet_id — NOT NULL

faqs

  • faq_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • type — enum('cash','account','auction','trade')
  • title — varchar(300) — NOT NULL
  • description — varchar(2000)

fcm_token 파이어베이스 메시지 토큰 (fcm_token)

  • fcm_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • fcm_token — varchar(500) — NOT NULL
  • user_id — int(11) — 외래 키 → users.user_id — NOT NULL

notices

  • notice_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • type — enum('main','advertisement') — NOT NULL
  • title — varchar(300) — NOT NULL
  • description — varchar(2000)

notification 알람설정 테이블 (notification)

  • notification_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • is_use_app_push — tinyint(4) — NOT NULL
  • is_use_auction_notification — tinyint(4) — NOT NULL
  • is_use_trade_notification — tinyint(4) — NOT NULL
  • is_use_event_notification — tinyint(4) — NOT NULL
  • user_id — int(11) — 외래 키 → users.user_id — NOT NULL

partners 아직 미사용\ (partners)

  • partner_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • partner_status — enum('active','delete','block') — NOT NULL
  • name — varchar(100) — NOT NULL
  • phone_number — varchar(30) — NOT NULL
  • email — varchar(500) — NOT NULL
  • resident_number_front — varchar(255) — NOT NULL
  • resident_number_back — varchar(255) — NOT NULL
  • gender — enum('male','female') — NOT NULL
  • age — int(11) — NOT NULL
  • channel_id — varchar(255) — 외래 키 → channels (유튜브 채널).channel_id — NOT NULL

rules

  • rule_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • rule_title — varchar(255) — NOT NULL
  • rule_type (추가되거나 딱 정해놓지 않아도 되기 때문에 enum으로 안해도 될듯??) — enum('sell','buy','bid','auction_participation','auction_rebid','trade','charging','withdraw') — NOT NULL

rules_items

  • rules_item_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • rule (content로 변경?) — varchar(255) — NOT NULL
  • rule_type — enum('normal','specific','part_normal','part_specific') — NOT NULL
  • rule_id — int(11) — 외래 키 → rules.rule_id — NOT NULL

sell_orders

  • sell_order_id — char(36) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • order_quantity (주문 개수) — int(11) — NOT NULL
  • traded_quantity (현재 체결된 개수) — int(11) — NOT NULL
  • order_price (주문 단가) — int(11) — NOT NULL
  • order_status — enum('ongoing','closed','cancel') — NOT NULL
  • channel_id — varchar(255) — 외래 키 → channels (유튜브 채널).channel_id — NOT NULL
  • user_id — int(11) — 외래 키 → users.user_id — NOT NULL

trade_daily_history (차트 일봉용) (trade_daily_history)

  • id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • opening_price (시작가) — int(10) — NOT NULL
  • closing_price (종가) — int(10) — NOT NULL
  • high — int(10) — NOT NULL
  • low — int(10) — NOT NULL
  • trade_count (총 거래 개수) — int(10) — NOT NULL
  • date — varchar(255) — NOT NULL
  • channel_id — varchar(255) — 외래 키 → channels (유튜브 채널).channel_id — NOT NULL

trade_history 상시거래 체결 이력 (trade_history)

  • trade_history_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • trade_type — enum('sell','sell_cancel','buy','buy_cancel') — NOT NULL
  • traded_quantity (체결된 개수) — int(11) — NOT NULL
  • unit_price (단가) — int(11) — NOT NULL
  • fee (수수료) — int(11) — NOT NULL
  • order_id — varchar(255) — NOT NULL
  • user_id — int(11) — 외래 키 → users.user_id — NOT NULL
  • channel_id — varchar(255) — 외래 키 → channels (유튜브 채널).channel_id — NOT NULL

trade_information

  • trade_information_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • start_price — int(11) — NOT NULL
  • end_price — int(11) — NOT NULL
  • max_price — int(11) — NOT NULL
  • min_price — int(11) — NOT NULL
  • traded_quantity — int(11) — NOT NULL
  • channel_id — varchar(255) — 외래 키 → channels (유튜브 채널).channel_id — NOT NULL

trade_rules

  • trade_rule_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • rule_title — varchar(255) — NOT NULL
  • rule_type — enum('sell','buy') — NOT NULL

trade_rules_items

  • trade_rules_item_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • rule — varchar(255) — NOT NULL
  • rule_type — enum('normal','specific') — NOT NULL
  • trade_rule_id — int(11) — 외래 키 → trade_rules.trade_rule_id — NOT NULL

trade_users 옥션 보유량 정보 (channel_pieces 로 네이밍 변경하기) (trade_users)

  • trade_users_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • user_id — int(11) — 외래 키 → users.user_id
  • available_quantity (옥션 보유 개수) — int(11) — NOT NULL
  • average_purchase_price (구매 평균 단가) — int(10) — NOT NULL
  • channel_id — varchar(255) — 외래 키 → channels (유튜브 채널).channel_id

trade_users_monthly_snapshots 유저 보유 지분 스냅샷 (trade_users_monthly_snapshots)

  • id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • amount (옥션 개수) — int(11) — NOT NULL
  • circulating_supply (스냅샷 당시의 유통량 (삭제가능?)) — int(11) — NOT NULL
  • user_id — int(11) — 외래 키 → users.user_id — NOT NULL
  • channel_profit_of_ad_id — int(11) — 외래 키 → channel_profit_of_ad 채널 광고 수익금 내역.id — NOT NULL

users

  • user_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • user_status (블랙리스트 테이블과 기능 구현하며 필요없어짐) — enum('active','delete','block') — NOT NULL
  • email — varchar(500) — NOT NULL
  • password — varchar(1000)
  • phone_number — varchar(30)
  • name — varchar(100) — NOT NULL
  • nickname — varchar(20)
  • date_of_birth — varchar(255) — NOT NULL
  • roles — enum('admin','user','guest') — NOT NULL
  • marketing_terms (마케팅 수신 동의 여부) — tinyint(4) — NOT NULL
  • unique_key (iamport 에서 본인인증 후 얻어오는 키) — varchar(255)
  • uid_kakao — varchar(255)
  • uid_apple — varchar(255)
  • walletEntityWalletId — char(36) — 외래 키 → wallets.wallet_id
  • notificationEntityNotificationId — int(11) — 외래 키 → notification 알람설정 테이블.notification_id
  • email_kakao — varchar(255)
  • email_apple — varchar(255)
  • gender — varchar(255)

verify_number

  • verify_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • phone — varchar(255) — NOT NULL
  • verify_number — int(11) — NOT NULL

version 앱 버전 테이블 (서버 점검상태를 결정한다.) (version)

  • id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • version_number — int(11) — NOT NULL
  • version_code — varchar(255) — NOT NULL
  • os — enum('android','ios') — NOT NULL
  • system_checkout — enum('Y','N') — NOT NULL

wallet_history 입출금 내역 (컨펌된 것들) (wallet_history)

  • wallet_history_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • type — enum('charging','withdrawal','auction','trade_sell','trade_buy','copyright_fee','event','etc') — NOT NULL
  • is_waiting (삭제해도 됨) — tinyint(4) — NOT NULL
  • description — varchar(500)
  • description_additional — varchar(100) — NOT NULL
  • order_quantity (주문옥션개수 (삭제해도될듯? 그리고 현재 정확히 어떤 주문인지 알 수 없음)) — int(11) — NOT NULL
  • order_price (구매/판매 옥션 단가 (삭제?)) — int(11) — NOT NULL
  • traded_quantity (거래/낙찰된 옥션 개수) — int(11) — NOT NULL
  • variable_amount (거래/낙찰된 금액) — int(11) — NOT NULL
  • fee — int(11) — NOT NULL
  • balance (거래후 잔액 (이름 수정? 최종금액 같은걸로)) — int(11) — NOT NULL
  • wallet_id — char(36) — 외래 키 → wallets.wallet_id — NOT NULL

wallet_staging_auction

  • wallet_staging_auction_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • type (삭제하기 (타입 필요 없음)) — enum('withdrawal','auction','order_sale','order_purchase') — NOT NULL
  • is_waiting (삭제하기 (필요 없음, 현재 소프트딜리트로 처리함)) — tinyint(4) — NOT NULL
  • staging_amount (옥션 입찰에 대한 대기금) — int(11) — NOT NULL
  • fee — int(11) — NOT NULL
  • description — varchar(500) — NOT NULL
  • description_additional — varchar(100) — NOT NULL
  • order_quantity (주문 개수) — int(11) — NOT NULL
  • order_price (주문 단가) — int(11) — NOT NULL
  • traded_quantity (삭제? 필요? (현재 사용되고있지 않음, + auction에 저장하기로 함)) — int(11) — NOT NULL
  • wallet_id — char(36) — 외래 키 → wallets.wallet_id
  • auction_id — char(36) — 외래 키 → auctions.auction_id

wallet_staging_exchange 입출금 대기내역 (wallet_staging_exchange)

  • wallet_staging_exchange_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • type — enum('withdrawal','charging') — NOT NULL
  • subtype — enum('waiting','cancel','confirm') — NOT NULL
  • description — varchar(255)
  • staging_amount (입/출금 예정 금액) — int(11) — NOT NULL
  • fee — int(11)
  • wallet_id — char(36) — 외래 키 → wallets.wallet_id — NOT NULL

wallets

  • wallet_id — char(36) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • account_number — varchar(100) — NOT NULL
  • accout_bank_name — varchar(100) — NOT NULL
  • account_owner_name — varchar(100) — NOT NULL
  • available_amount (사용가능 금액) — int(11) — NOT NULL
  • staging_amount (대기금) — int(11) — NOT NULL
  • user_id — int(11) — 외래 키 → users.user_id — NOT NULL
  • resident_registration_head (주민번호 앞자리) — varchar(6) — NOT NULL
  • resident_registration_tail (주민번호 뒷자리) — varchar(7) — NOT NULL