gg
Tables (27)
active_storage_blobs
- id — bigint(20) — Primary key — NOT NULL
- key — varchar(255) — NOT NULL
- filename — varchar(255) — NOT NULL
- content_type — varchar(255)
- metadata — text
- byte_size — bigint(20) — NOT NULL
- checksum — varchar(255) — NOT NULL
- created_at — datetime — NOT NULL
app_configs
- id — bigint(20) — Primary key — NOT NULL
- aos_min_version — varchar(255)
- ios_min_version — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
ar_internal_metadata
- key — varchar(255) — Primary key — NOT NULL
- value — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
articles
- id — bigint(20) — Primary key — NOT NULL
- board_id (id2) — bigint(20) — Foreign key → boards.id — NOT NULL
- title — varchar(255)
- body — text
- user_id — bigint(20)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- extra — text
billing_infos
- id — bigint(20) — Primary key — NOT NULL
- user_id (id2) — bigint(20) — Foreign key → users.id — NOT NULL
- user_id — bigint(20)
- cardno — varchar(255)
- card_code — varchar(255)
- card_name — varchar(255)
- exp_date — varchar(255)
- card_cl — varchar(255)
- result_code — varchar(255)
- result_msg — varchar(255)
- bid — varchar(255)
- auth_date — varchar(255)
- is_active — tinyint(1)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- extra — text
- result_raw — text
- tid — varchar(255)
- pg — int(11)
boards
- id — bigint(20) — Primary key — NOT NULL
- title — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
cabinet_logs
- id — bigint(20) — Primary key — NOT NULL
- cabinet_id — int(11)
- event — int(11)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
cabinet_online_statuses
- id — bigint(20) — Primary key — NOT NULL
- cabinet_category — int(11)
- cabinet_count — int(11)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
cabinets
- id — bigint(20) — Primary key — NOT NULL
- serialno — varchar(255)
- installation_site_id — int(11)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- online_status — int(11)
- extra — text
comments
- id — bigint(20) — Primary key — NOT NULL
- comment_type — int(11)
- content — text
- extra — text
- commentable_id — bigint(20)
- commentable_type — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- user_id — int(11)
coupons
- id — bigint(20) — Primary key — NOT NULL
- user_id (id2) — bigint(20) — Foreign key → users.id — NOT NULL
- coupon_name — varchar(255)
- coupon_code — varchar(255)
- coupon_type — int(11)
- sent_at — datetime
- user_id — int(11)
- extra — text
hashtags
- id — bigint(20) — Primary key — NOT NULL
- hashtag_type — int(11)
- content — varchar(255)
- extra — text
- hashtaggable_id — bigint(20)
- hashtaggable_type — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
installation_sites
- id — bigint(20) — Primary key — NOT NULL
- user_id (id2) — bigint(20) — Foreign key → users.id — NOT NULL
- name — varchar(255)
- address — varchar(255)
- zipcode — varchar(255)
- lat — float
- lng — float
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- user_id — int(11)
- short_description — varchar(255)
- open_hours — varchar(255)
- closed_days — varchar(255)
- site_category_id — int(11)
- business_register_number — varchar(255)
- sites_sales — int(11)
- phone — varchar(255)
- seconds_for_free — int(11)
money_transfers
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — NOT NULL
- amount — int(11)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- transfered_on — date
pg_billing_pays
- id — bigint(20) — Primary key — NOT NULL
- user_id (id2) — bigint(20) — Foreign key → users.id — NOT NULL
- billing_info_id — bigint(20)
- user_id — bigint(20)
- result_code — varchar(255)
- result_msg — varchar(255)
- auth_date — varchar(255)
- goods_name — varchar(255)
- pay_method — varchar(255)
- tid — varchar(255)
- moid — varchar(255)
- amount — int(11)
- card_cl — varchar(255)
- auth_code — varchar(255)
- card_code — varchar(255)
- card_name — varchar(255)
- card_no — varchar(255)
- card_quota — varchar(255)
- acqu_card_code — varchar(255)
- acqu_card_name — varchar(255)
- pg — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- cancel_result_code — varchar(255)
- cancel_result_msg — varchar(255)
- cancel_amount — int(11)
- cancel_date — varchar(255)
- cancel_time — varchar(255)
- cancel_num — varchar(255)
- cancel_error_cd — varchar(255)
- cancel_error_msg — varchar(255)
- cancel_auth_date — varchar(255)
- rental_id — bigint(20)
- using_time — int(11)
- extra — text
phone_number_verifies
- id — bigint(20) — Primary key — NOT NULL
- phone — varchar(255)
- auth_num — varchar(255)
- verified — tinyint(1)
- expired_at — datetime
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
power_bank_logs
- id — bigint(20) — Primary key — NOT NULL
- power_bank_id — bigint(20) — NOT NULL
- cabinet_id — bigint(20)
- event — int(11)
- message — text
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
power_banks
- id — bigint(20) — Primary key — NOT NULL
- cabinet_id (id2) — bigint(20) — Foreign key → cabinets.id — NOT NULL
- serialno — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- status — int(11)
rental_logs
- id — bigint(20) — Primary key — NOT NULL
- rental_id — bigint(20)
- power_bank_id — bigint(20)
- lockid — varchar(255)
- event — int(11)
- message — text
- borrow_data — text
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
rentals
- id — bigint(20) — Primary key — NOT NULL
- user_id (id2) — bigint(20) — Foreign key → users.id — NOT NULL
- cabinet_id (id3) — bigint(20) — Foreign key → cabinets.id — NOT NULL
- power_bank_id — int(11)
- returned_at — datetime
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- lockid — varchar(255)
- using_time — int(11)
- site_name — varchar(255)
- total_amount — int(11)
- installation_site_id — int(11)
- requested_at — datetime
- request_serialno — varchar(255)
- revenue — int(11)
- extra — text
revenue_shares
- id — bigint(20) — Primary key — NOT NULL
- id (id2) — bigint(20) — Foreign key → users.id — NOT NULL
- rental_id — bigint(20) — NOT NULL
- ratio — float
- amount — int(11)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
site_categories
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
sites_sales
- id — bigint(20) — Primary key — NOT NULL
- user_id (id2) — bigint(20) — Foreign key → users.id — NOT NULL
- installation_site_id — int(11)
- profit_ratio — float
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
sms_send_histories
- id — bigint(20) — Primary key — NOT NULL
- dest_phone — varchar(255)
- msg_body — text
- send_result_code — varchar(255)
- send_result_text — varchar(255)
- cmid — varchar(255)
- report_time — varchar(255)
- call_status — varchar(255)
- umid — varchar(255)
- send_type — int(11)
- created_at — datetime
- updated_at — datetime
- extra — text
sns_identities
- id — bigint(20) — Primary key — NOT NULL
- user_id (id2) — bigint(20) — Foreign key → users.id — NOT NULL
- uid — varchar(255) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- provider — int(11) — NOT NULL
users
- id — bigint(20) — Primary key — NOT NULL
- loginname — varchar(255)
- password_digest — varchar(255)
- role — int(11)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- name — varchar(255)
- agree_to_marketing — tinyint(1)
- birthday — date
- phone — varchar(255)
- agree_to_push_alarm — tinyint(1)
- extra — text
- bank_code — varchar(255)
- bank_account — varchar(255)
- bank_owner_name — varchar(255)
- device_type — varchar(255)
- device_key — varchar(255)
- referral_code — varchar(255)
web_urls
- id — bigint(20) — Primary key — NOT NULL
- url — varchar(255)
- installation_site_id — int(11)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL