벤지레이치

테이블 (30)

cities

  • id — int(10) — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • region — varchar(255) — NOT NULL
  • currency — varchar(255) — NOT NULL
  • balance — double — NOT NULL
  • timezone — varchar(255)
  • deleted_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp

city_delivery_group

  • id — int(10) — 기본 키 — NOT NULL
  • delivery_group_id — int(10) — NOT NULL
  • city_id — int(10) — 외래 키 → cities.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — datetime

city_penalties

  • id — int(10) — 기본 키 — NOT NULL
  • week_id — int(10) — NOT NULL
  • city_id — int(10) — 외래 키 → cities.id — NOT NULL
  • startup_adjust_rate — int(11) — NOT NULL
  • deleted_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp

city_reports

  • id — int(10) — 기본 키 — NOT NULL
  • week_id — int(10) — NOT NULL
  • city_id — int(10) — 외래 키 → cities.id — NOT NULL
  • week_till_total — double — NOT NULL
  • week_participants_total — int(11) — NOT NULL
  • twenty_percent — double — NOT NULL
  • status — int(11) — NOT NULL
  • deleted_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp
  • community_fee — double — NOT NULL

city_user

  • id — int(10) — 기본 키 — NOT NULL
  • user_id — int(10) — NOT NULL
  • city_id — int(10) — 외래 키 → cities.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — datetime

delivery_groups

  • id — int(10) — 기본 키 — NOT NULL
  • user_id — int(10) — NOT NULL
  • name — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — datetime

delivery_prices

  • id — int(10) — 기본 키 — NOT NULL
  • delivery_group_id — int(10) — 외래 키 → delivery_groups.id — NOT NULL
  • min — int(11) — NOT NULL
  • max — int(11) — NOT NULL
  • price — double — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — datetime

ding_users

  • id — int(10) — 기본 키 — NOT NULL
  • ding_id — int(10) — 외래 키 → dings.id
  • user_id — int(10)
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

dings

  • id — int(10) — 기본 키 — NOT NULL
  • owner_id — int(10) — NOT NULL
  • city_id — int(10) — 외래 키 → cities.id — NOT NULL
  • angel_id — int(10)
  • subject — varchar(255)
  • type_id — int(11) — NOT NULL
  • value1 — varchar(255)
  • value2 — varchar(255)
  • value3 — varchar(255)
  • image — varchar(255)
  • url — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp
  • parent_id — int(10)

event_reports

  • id — int(10) — 기본 키 — NOT NULL
  • week_id — int(10) — NOT NULL
  • event_id — int(10) — NOT NULL
  • city_report_id — int(10) — 외래 키 → city_reports.id — NOT NULL
  • participants — int(11) — NOT NULL
  • till — double — NOT NULL
  • twenty_percent — double — NOT NULL
  • deleted_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp

event_user

  • id — int(10) — 기본 키 — NOT NULL
  • user_id — int(10) — NOT NULL
  • event_id — int(10) — 외래 키 → events.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — datetime

events

  • id — int(10) — 기본 키 — NOT NULL
  • image — varchar(255)
  • day_of_week — int(11)
  • place — varchar(255)
  • street_address — varchar(255)
  • time — varchar(255)
  • contact_name — varchar(255)
  • contact_phone — varchar(255)
  • city_id — int(10) — 외래 키 → cities.id — NOT NULL
  • deleted_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp
  • facebook_link — varchar(255)
  • meetup_link — varchar(255)
  • neighborhood — varchar(255)
  • province — varchar(255)
  • post_code — varchar(255)

failed_jobs

  • id — bigint(20) — 기본 키 — NOT NULL
  • connection — text — NOT NULL
  • queue — text — NOT NULL
  • payload — longtext — NOT NULL
  • exception — longtext — NOT NULL
  • failed_at — timestamp — NOT NULL

flag_order

  • id — int(10) — 기본 키 — NOT NULL
  • order_id — int(10) — NOT NULL
  • flag_id — int(10) — 외래 키 → flags.id — NOT NULL
  • amount — int(11) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — datetime

flag_user

  • id — int(10) — 기본 키 — NOT NULL
  • user_id — int(10) — 외래 키 → users.id — NOT NULL
  • flag_id — int(10) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — datetime

flags

  • id — int(10) — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • image — varchar(255) — NOT NULL
  • is_language — int(11) — NOT NULL
  • type — int(11) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

inquiries

  • id — int(10) — 기본 키 — NOT NULL
  • name — varchar(255)
  • email — varchar(255)
  • subject — varchar(255)
  • message — text
  • created_at — timestamp
  • updated_at — timestamp

inventories

  • id — int(10) — 기본 키 — NOT NULL
  • user_id — int(10) — NOT NULL
  • flag_id — int(10) — 외래 키 → flags.id — NOT NULL
  • amount — int(11) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — datetime

migrations

  • id — int(10) — 기본 키 — NOT NULL
  • migration — varchar(255) — NOT NULL
  • batch — int(11) — NOT NULL

orders

  • id — int(10) — 기본 키 — NOT NULL
  • user_id — int(10) — NOT NULL
  • supplier_id — int(10) — 외래 키 → users.id
  • shipping_address_1 — varchar(255)
  • shipping_address_2 — varchar(255)
  • shipping_address_zip — varchar(255)
  • billing_address_1 — varchar(255)
  • billing_address_2 — varchar(255)
  • billing_address_zip — varchar(255)
  • bitcoin_address — varchar(255)
  • bitcoin_secret — varchar(255)
  • transaction_hash — varchar(255)
  • satoshi_amount — int(11)
  • confirmation_times — int(11)
  • total_amount — double — NOT NULL
  • delivery_cost — double — NOT NULL
  • status — int(11) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • tracking_number — varchar(255)
  • deleted_at — datetime

password_resets

  • email — varchar(255) — NOT NULL
  • token — varchar(255) — NOT NULL
  • created_at — timestamp

payments

  • id — int(10) — 기본 키 — NOT NULL
  • user_id — int(10) — NOT NULL
  • city_id — int(10) — 외래 키 → cities.id — NOT NULL
  • currency — varchar(255)
  • bitcoin_address — varchar(255)
  • bitcoin_secret — varchar(255)
  • transaction_hash — varchar(255)
  • satoshi_amount — int(11)
  • confirmation_times — int(11)
  • total_amount — double — NOT NULL
  • status — int(11) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — datetime
  • type — int(11) — NOT NULL

receipts

  • id — int(10) — 기본 키 — NOT NULL
  • owner_id — int(11) — NOT NULL
  • city_id — int(10) — 외래 키 → cities.id — NOT NULL
  • angel_id — int(10)
  • subject — varchar(255)
  • type_id — int(11) — NOT NULL
  • value1 — varchar(255)
  • value2 — varchar(255)
  • value3 — varchar(255)
  • image — varchar(255)
  • url — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

report_weeks

  • id — int(10) — 기본 키 — NOT NULL
  • week_number — int(11) — NOT NULL
  • begins_at — date — NOT NULL
  • ends_at — date — NOT NULL
  • deleted_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp

reports

  • id — int(10) — 기본 키 — NOT NULL
  • event_id — int(10) — 외래 키 → events.id — NOT NULL
  • participant_amount — int(11)
  • bar_cost — varchar(255)
  • bar_revenue — varchar(255)
  • currency — varchar(255)
  • receipt — varchar(255)
  • deleted_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp

rp_keys

  • id — int(10) — 기본 키 — NOT NULL
  • rp_id — int(10) — 외래 키 → dings.id — NOT NULL
  • key — varchar(255) — NOT NULL
  • score — int(11) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

supplier_finances

  • id — int(10) — 기본 키 — NOT NULL
  • supplier_id — int(10) — 외래 키 → users.id — NOT NULL
  • concept — int(11) — NOT NULL
  • cash_in_out — double — NOT NULL
  • btc_in_out — double — NOT NULL
  • date_of_transaction — date — NOT NULL
  • receipt — varchar(255) — NOT NULL
  • transaction_type — varchar(255)
  • satoshi_amount — int(11)
  • currency — varchar(255) — NOT NULL
  • cash_balance — double — NOT NULL
  • btc_balance — double — NOT NULL
  • deleted_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp

surveys

  • id — int(10) — 기본 키 — NOT NULL
  • first_name — varchar(255)
  • last_name — varchar(255)
  • email — varchar(255)
  • tools — text
  • offers — text
  • city_type_text — varchar(255)
  • city — varchar(255)
  • facebook — varchar(255)
  • skype — varchar(255)
  • role — varchar(255)
  • resume — varchar(255)
  • languages — text
  • description — text
  • weakness — varchar(255)
  • strength — varchar(255)
  • why_angry — varchar(255)
  • why_laugh — varchar(255)
  • interests — text
  • created_at — timestamp
  • updated_at — timestamp

users

  • id — int(10) — 기본 키 — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • first_name — varchar(255)
  • last_name — varchar(255)
  • role_type — int(11) — NOT NULL
  • purpose_role_type_1 — int(11)
  • VL — int(11) — NOT NULL
  • avatar — varchar(255)
  • supplier_flag_weight — int(11)
  • remember_token — varchar(100)
  • created_at — timestamp
  • updated_at — timestamp
  • verified_at — datetime
  • deleted_at — datetime
  • biography — text

users_aux

  • id — int(10) — 기본 키 — NOT NULL
  • user_id — int(10) — 외래 키 → users.id — NOT NULL
  • telephone — varchar(255)
  • telegram — varchar(255)
  • address — varchar(255)
  • website — varchar(255)
  • business_name — varchar(255)
  • onboard — int(11) — NOT NULL
  • contract — varchar(255)
  • deleted_at — datetime
  • created_at — timestamp
  • updated_at — timestamp