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)