k]

Tables (33)

alarm_histories (알림 기록)

  • id — Primary key — NOT NULL
  • uid
  • user_id (user) — Foreign key → users.id — NOT NULL
  • alarmable_type
  • alarmable_id
  • message
  • jid
  • sent_at
  • created_at
  • updated_at

attachments (첨부파일)

  • id — Primary key — NOT NULL
  • uid
  • url
  • file_name
  • extenstion (extension)
  • attachmentable_type
  • attachmentable_id
  • created_at
  • updated_at
  • deleted_at

auth_histories (인증(SMS인증) 기록)

  • id — Primary key — NOT NULL
  • user_id (user) — Foreign key → users.id — NOT NULL
  • code
  • status
  • expired_at
  • created_at
  • updated_at
  • deleted_at

broom_details (심부름 세부내역)

  • id (Key) — Primary key — NOT NULL
  • note
  • start_time
  • end_time
  • price
  • point_amount
  • admob_amount
  • coupon_amount
  • coupon_point_amount
  • created_at
  • updated_at
  • deleted_at

broom_histories (심부름 거래내역)

  • id — Primary key — NOT NULL
  • uid
  • broom_id (broom) — Foreign key → brooms.id — NOT NULL
  • broomer_id (broomer) — Foreign key → users.id — NOT NULL
  • broomy_id (broomy) — Foreign key → users.id — NOT NULL
  • status
  • created_at
  • updated_at
  • deketed_at (deleted_at)

broom_reviews (심부름 리뷰)

  • id — Primary key — NOT NULL
  • uid
  • reviewer_user_id (reviewer_user) — Foreign key → users.id — NOT NULL
  • reviewed_user_id (reviewed_user) — Foreign key → users.id — NOT NULL
  • broom_id (broom) — Foreign key → brooms.id — NOT NULL
  • star
  • review
  • to_broomy
  • create_at (created_at)
  • updated_at
  • deleted_at

brooms (심부름)

  • id — Primary key — NOT NULL
  • uid
  • broomer_id (broomer) — Foreign key → users.id — NOT NULL
  • details_id (details) — Foreign key → broom_details.id — NOT NULL
  • category_id (category) — Foreign key → categories.id — NOT NULL
  • destination_id (destination) — Foreign key → locations.id — NOT NULL
  • trade_status
  • expired_at
  • created_at
  • updated_at
  • deleted_at

broomy_badge (Untitled)

  • id (Key) — Primary key — NOT NULL
  • uid (Field4)
  • broomy_profile_id (Key2) — Foreign key → broomy_profiles.id — NOT NULL
  • badge_id (Key3) — Foreign key → categories.id — NOT NULL
  • created_at (Field)
  • updated_at (Field2)
  • deleted_at (Field3)

broomy_confirm_histories (부르미 등록 신청 내역)

  • id (Key) — Primary key — NOT NULL
  • broomy_profile_id (Key2) — Foreign key → broomy_profiles.id — NOT NULL
  • email (Field6)
  • previous_status (Field)
  • current_status (Field2)
  • reason (Field7)
  • timestamp (Field3)
  • created_at (Field4)
  • updated_at (Field5)

broomy_profiles (부르미 정보)

  • id (Key) — Primary key — NOT NULL
  • uid (Field)
  • thumbnail_id (Key2) — Foreign key → images.id — NOT NULL
  • introduce (Field2)
  • gender (Field6)
  • birth (Field7)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)

broomy_specialities (부르미 특기)

  • id (Key) — Primary key — NOT NULL
  • uid (Field6)
  • broomy_profile_id (Key2) — Foreign key → broomy_profiles.id — NOT NULL
  • name (Field)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)

categories (카테고리)

  • id (Key) — Primary key — NOT NULL
  • uid (Field)
  • name (Field2)
  • code (Field3)
  • type (Field7)
  • created_at (Field4)
  • updated_at (Field5)
  • deleted_at (Field6)

chat_members (채팅 멤버)

  • id (Key2) — Primary key — NOT NULL
  • chat_id (Key) — Foreign key → chats.id — NOT NULL
  • user_id (Key3) — Foreign key → users.id — NOT NULL
  • is_broomer (Field)
  • status (Field5)
  • created_at (Field2)
  • updated_at (Field3)
  • deleted_at (Field4)

chat_messages (채팅 메시지)

  • id (Key) — Primary key — NOT NULL
  • uid (Field)
  • chat_id (Key2) — Foreign key → chats.id — NOT NULL
  • chat_member_id (Key22) — Foreign key → chat_members.id — NOT NULL
  • message (Field2)
  • time_token (Field3)
  • created_at (Field4)
  • updated_at (Field5)
  • deleted_at (Field6)

chats (채팅)

  • id (Key) — Primary key — NOT NULL
  • uid (Field)
  • broom_id (Key2) — Foreign key → brooms.id — NOT NULL
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)

commissions (수수료)

  • id (Key) — Primary key — NOT NULL
  • broom_id (Key2) — Foreign key → brooms.id — NOT NULL
  • status (Field)
  • percent (Field8)
  • comission (Field2)
  • previous_comission (Field6)
  • current_commission (Field7)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)

coupon_histories (쿠폰 등록/사용 내역)

  • id (Key) — Primary key — NOT NULL
  • uid (Field10)
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • status (Field)
  • status_type (Field5)
  • coupon_id (Field8)
  • broom_id (Field9)
  • previous_coupon_point (Field11)
  • previous_coupon (Field6)
  • current_coupon (Field7)
  • created_at (Field2)
  • updated_at (Field3)
  • deleted_at (Field4)

coupon_points (사용자 보유 쿠폰 포인트)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • total_coupon_point (Field)
  • created_at (Field2)
  • updated_at (Field3)
  • deleted_at (Field4)

coupons (쿠폰)

  • id (Key) — Primary key — NOT NULL
  • uid (Field)
  • name (Field2)
  • code (Field3)
  • point (Field4)
  • amount (Field9)
  • used_amount (Field10)
  • expired_at (Field8)
  • created_at (Field5)
  • updated_at (Field6)
  • deleted_at (Field7)

deposit_histories (입금 내역)

  • id (Key) — Primary key — NOT NULL
  • uid (Field14)
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • point_history_id (Key3) — Foreign key → point_histories.id — NOT NULL
  • platform (Field10)
  • amount (Field11)
  • key_id (Field12)
  • end_point (Field)
  • request_method (Field2)
  • request_headers (Field3)
  • request_body (Field4)
  • response_status (Field5)
  • response_headers (Field6)
  • response_body (Field7)
  • created_at (Field8)
  • updated_at (Field9)
  • deleted_at (Field13)

images (이미지)

  • id (Key) — Primary key — NOT NULL
  • uid (Field)
  • url (Field2)
  • pos (Field7)
  • imageable_type (Field3)
  • imageable_id (Field8)
  • created_at (Field4)
  • updated_at (Field5)
  • deleted_at (Field6)

location_metadata (위치 부가 정보)

  • id (Key) — Primary key — NOT NULL
  • location_id (Key2) — Foreign key → locations.id — NOT NULL
  • wifi (Field)
  • cell (Field2)
  • ble (Field3)
  • created_at (Field4)
  • updated_at (Field5)

locations (위치)

  • id (Key) — Primary key — NOT NULL
  • latitude (Field)
  • longitude (Field2)
  • altitude (Field3)
  • accuracy (Field4)
  • address (Field5)
  • status (Field9)
  • created_at (Field6)
  • updated_at (Field7)
  • deleted_at (Field8)

point_histories (포인트 입출금 내역)

  • id (Key) — Primary key — NOT NULL
  • uid (Field9)
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • status (Field2)
  • status_type (Field6)
  • broom_id (Field8)
  • previos_point (Field)
  • current_point (Field7)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)

points (사용자 보유 포인트)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • total_point (Field)
  • point_amount (Field5)
  • admob_amount (Field6)
  • coupon_amount (Field7)
  • created_at (Field2)
  • updated_at (Field3)
  • deleted_at (Field4)

reporters (유저 신고)

  • id (Key) — Primary key — NOT NULL
  • reportable_type (Field)
  • reportable_id (Field6)
  • reporter_user_id (Key2) — Foreign key → users.id — NOT NULL
  • reported_user_id (Key3) — Foreign key → users.id — NOT NULL
  • reason (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)

short_urls (short url)

  • id (Key) — Primary key — NOT NULL
  • uid (Field)
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • broom_id (Key3) — Foreign key → brooms.id — NOT NULL
  • read_at (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)

transaction_histories (거래 내역 기록)

  • id — Primary key — NOT NULL
  • uid
  • user_id (user) — Foreign key → users.id — NOT NULL
  • stautus (Field)
  • trade_status (Field6)
  • previous_point (Field7)
  • current_point (Field2)
  • previous_coupon (Field5)
  • current_coupon (Field8)
  • created_at (Field3)
  • updated_at (Field4)
  • Field12

user_block (유저 차단)

  • id (Key) — Primary key — NOT NULL
  • uid (Field)
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • blockable_type (Field2)
  • blockable_id (Field6)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)

user_preferences (유저 설정)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key3) — Foreign key → users.id — NOT NULL
  • feature_push (true)
  • created_at (Field2)
  • updated_at (Field3)
  • deleted_at (Field4)

user_roles (유저 역할)

  • id (Key) — Primary key — NOT NULL
  • uid (Field)
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • role (Field2)
  • created_at (Field3)
  • updated_at (Field5)
  • deleted_at (Field4)

users (유저)

  • id — Primary key — NOT NULL
  • uid (Field)
  • broomy_profile_id (Key2) — Foreign key → broomy_profiles.id — NOT NULL
  • cellphone (Field2)
  • nickname (Field3)
  • status (Field4)
  • terms (false)
  • star (Field8)
  • created_at (Field5)
  • updated_at (Field6)
  • deleted_at (Field7)

withdrawal_histories (인출 내역)

  • id (Key) — Primary key — NOT NULL
  • uid (Field13)
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • point_history_id (Key3) — Foreign key → point_histories.id — NOT NULL
  • name (Field6)
  • bank (Field2)
  • account (Field)
  • registration_number (Field5)
  • withdrawal_amount (Field8)
  • point_amount (Field9)
  • admob_amount (Field10)
  • coupon_amount (Field11)
  • sent_at (Field7)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field12)