벤지레이치
테이블 (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