Spree ERD

Spree ERD

Transcript

1. SpreeDemo domain model Spree::Activator advertise boolean code string description string event_name string expires_at datetime match_policy string name string path string starts_at datetime usage_limit integer Spree::Address address1 string ∗ address2 string alternative_phone string city string ∗ company string firstname string ∗ lastname string ∗ phone string ∗ state_name string zipcode string ∗ Spree::LegacyUser authentication_token string current_sign_in_at datetime current_sign_in_ip string email string encrypted_password string (128) failed_attempts integer ∗ last_request_at datetime last_sign_in_at datetime last_sign_in_ip string locked_at datetime login string password_salt string (128) perishable_token string persistence_token string remember_created_at datetime remember_token string reset_password_sent_at datetime reset_password_token string sign_in_count integer ∗ spree_api_key string (48) unlock_token string Spree::Order adjustment_total decimal (10,2) ∗ bill_address_id integer channel string completed_at datetime currency string email string ∗ item_total decimal (10,2) ∗ last_ip_address string number string (32) payment_state string payment_total decimal (10,2) ship_address_id integer shipment_state string shipping_method_id integer special_instructions text state string total decimal (10,2) ∗ Spree::Shipment cost decimal (8,2) number string shipped_at datetime state string tracking string Spree::User authentication_token string current_sign_in_at datetime current_sign_in_ip string email string ∗ encrypted_password string (128) failed_attempts integer ∗ last_request_at datetime last_sign_in_at datetime last_sign_in_ip string locked_at datetime login string password_salt string (128) perishable_token string persistence_token string remember_created_at datetime remember_token string reset_password_sent_at datetime reset_password_token string sign_in_count integer ∗ spree_api_key string (48) unlock_token string Spree::Adjustment adjustable_type string amount decimal (10,2) eligible boolean label string ∗ mandatory boolean originator_type string source_type string state string Spree::Asset alt text attachment_content_type string attachment_file_name string attachment_file_size integer attachment_height integer attachment_updated_at datetime attachment_width integer position integer viewable_type string Spree::Calculator calculable_type string Spree::Classification Spree::Configuration name string Spree::Country iso string iso3 string iso_name string ∗ name string ∗ numcode integer states_required boolean Spree::State abbr string name string ∗ Spree::StockLocation active boolean address1 string address2 string admin_name string backorderable_default boolean city string name string ∗ phone string propagate_all_variants boolean state_name string zipcode string Spree::CreditCard address_id integer cc_type string first_name string gateway_customer_profile_id string gateway_payment_profile_id string last_digits string last_name string month string year string Spree::LogEntry details text source_type string Spree::Payment amount decimal (10,2) ∗ avs_response string cvv_response_code string cvv_response_message string identifier string response_code string source_type string state string Spree::InventoryUnit pending boolean state string Spree::LineItem cost_price decimal (8,2) currency string price decimal (8,2) ∗ quantity integer ∗ Spree::Product available_on datetime deleted_at datetime description text meta_description text meta_keywords string name string ∗ permalink string ∗ Spree::OptionType name string (100) ∗ position integer ∗ presentation string (100) ∗ Spree::OptionValue name string ∗ position integer presentation string ∗ Spree::ProductOptionType position integer Spree::Prototype name string ∗ Spree::Variant cost_currency string cost_price decimal (8,2) deleted_at datetime depth decimal (8,2) height decimal (8,2) is_master boolean position integer sku string ∗ track_inventory boolean weight decimal (8,2) width decimal (8,2) Spree::ReturnAuthorization amount decimal (10,2) ∗ number string reason text state string stock_location_id integer Spree::StateChange name string next_state string previous_state string stateful_type string Spree::TokenizedPermission permissable_type string token string Spree::PaymentMethod active boolean deleted_at datetime description text display_on string environment string name string ∗ Spree::Preference key string ∗ value text value_type string ∗ Spree::Price amount decimal (8,2) currency string Spree::ProductProperty position integer value string Spree::PromotionRule product_group_id integer user_id integer Spree::Property name string ∗ presentation string ∗ Spree::StockItem backorderable boolean count_on_hand integer ∗ deleted_at datetime Spree::Taxon depth integer description text icon_content_type string icon_file_name string icon_file_size integer icon_updated_at datetime lft integer meta_description string meta_keywords string meta_title string name string ∗ permalink string position integer rgt integer Spree::PromotionAction position integer Spree::PromotionActionLineItem quantity integer Spree::Role name string Spree::ShippingMethod admin_name string deleted_at datetime display_on string name string ∗ tracking_url string Spree::ShippingRate cost decimal (8,2) selected boolean Spree::ShippingCategory name string ∗ Spree::ShippingMethodCategory Spree::Zone default_tax boolean description string name string ∗ zone_members_count integer Spree::StockMovement action string originator_type string quantity integer ∗ Spree::StockTransfer number string reference string Spree::TaxCategory deleted_at datetime description string is_default boolean name string ∗ Spree::TaxRate amount decimal (8,5) ∗ deleted_at datetime included_in_price boolean name string show_rate_in_label boolean Spree::Taxonomy name string ∗ position integer Spree::Tracker active boolean analytics_id string environment string Spree::ZoneMember zoneable_id integer zoneable_type string