Ellieo
Tables (25)
buildings (Untitled12)
- idx (Index) — PK — Primary key — NOT NULL
- zip_idx (Zip Index) — FK — Foreign key → zips.user_idx — NOT NULL
- user_idx (User Index) — FK — Foreign key → users.idx — NOT NULL
- address (Address) — AES Encrypt
- latitude (Latitude)
- longitude (Longitude)
- geometry (Location)
- created_at (Created Date)
- updated_at (Updated Date)
category_lifestyles (Untitled24)
- idx (Index) — PK — Primary key — NOT NULL
- idx (Index2) — PK — Foreign key → user_lifestyles.idx — NOT NULL
- user_idx (User Index) — FK — Foreign key → user_lifestyles.user_idx — NOT NULL
- name (Name)
- orer (Lifestyle Order)
- created_at (Created Date)
- updated_at (Updated Date)
category_rent_amenities (Untitled16)
- idx (Index) — PK — Primary key — NOT NULL
- name (Name)
- src (Picture)
- order (Picture Order)
category_rent_features (Untitled18)
- idx (Index) — PK — Primary key — NOT NULL
- name (Name)
- src (Picture)
- order (Picture Order)
category_rent_room_types (Untitled23)
- idx (Index) — PK — Primary key — NOT NULL
- name (Name)
- order (Room Order)
- created_at (Created Date)
- updated_at (Updated Date)
- is_active (Room Active)
category_rent_utilities (Untitled20)
- idx (Index) — PK — Primary key — NOT NULL
- name (Name)
- src (Picture)
- order (Picture Order)
rent_amenities (Untitled15)
- idx (Index) — PK — Primary key — NOT NULL
- rent_idx (Rent Index) — FK — Foreign key → rents.idx — NOT NULL
- amenity_category_idx (Amenity Category Index) — FK — Foreign key → category_rent_amenities.idx — NOT NULL
rent_features (Untitled17)
- idx (Index) — PK — Primary key — NOT NULL
- rent_idx (Rent Index) — FK — Foreign key → rents.idx — NOT NULL
- feature_category_idx (Feature Category Index) — FK — Foreign key → category_rent_features.idx — NOT NULL
rent_free_month (Untitled21)
- idx (Index) — PK — Primary key — NOT NULL
- rent_idx (Rent Index) — FK — Foreign key → rents.idx — NOT NULL
- month (Month)
- term (Term)
rent_images (Untitled14)
- idx (Index) — PK — Primary key — NOT NULL
- rent_idx (Rent Index) — FK — Foreign key → rents.idx — NOT NULL
- src (Rent Image)
- order (Image order)
rent_room_prices (Untitled22)
- idx (Index) — PK — Primary key — NOT NULL
- rent_idx (Rent Index) — FK — Foreign key → rents.idx — NOT NULL
- room_type_idx (Room Type Index) — FK — Foreign key → category_rent_room_types.idx — NOT NULL
- price (Price)
rent_utilities (Untitled19)
- idx (Index) — PK — Primary key — NOT NULL
- rent_idx (Rent Index) — FK — Foreign key → rents.idx — NOT NULL
- utility_category_idx (Utility Category Index) — FK — Foreign key → category_rent_utilities.idx — NOT NULL
rents (Untitled13)
- idx (Index) — PK — Primary key — NOT NULL
- building_idx (Building Index) — FK — Foreign key → buildings.user_idx — NOT NULL
- user_idx (User Index) — FK — Foreign key → users.idx — NOT NULL
- address (Address) — AES Encrypt
- unit (Unit) — i
- property_type (Property Type) — 0=Apartment, 1=Walk-up, 2=House, 3=Dormitory
- bed (Bedroom Count)
- bath (Bathroom Count)
- layout (Layout)
- move_in_month (Move-in Month)
- move_in_period (Move-in Period) — 0=Early, 1=Mid, 2=Late
- promotion (Promotion) — 0=No Broker Fee, 1=Reduced Deposit
- lease_term (Lease Term) — 0=0-6 months, 1=6-12 months, 2=Over 12months
- lease_type (Lease Type) — 0=New Lease, 1=Roommate only, 2= Lease takeover, 3=Sublease
- created_at (Created At)
- updated_at (Updated At)
- is_active (Listing Active) — 0_Not displayed; 1_Displayed
schools (Untitled25)
- idx (Index) — PK — Primary key — NOT NULL
- user_idx (User Index) — FK — Foreign key → users.idx — NOT NULL
- name (Name)
- email (School Email)
- created_at (Created At)
- updated_at (Updated At)
user_agents (Untitled2)
- idx (Index) — PK — Primary key — NOT NULL
- admin_user_idx (Admin Index) — FK — Primary key
- user_idx (User Index) — FK — Foreign key → users.idx — NOT NULL
- brokerage (Brokerage)
- license_name (Name on License)
- license_number (License Number)
- license_src (License Photo)
- license_selfie_src (Selfie with License)
- is_status (Agent Status) — 0=Rejected; 1=Being reviewed; 2=Approved
- created_at (Created Date)
- updated_at (Updated Date)
- reject_reason (Reject Reason)
user_device_tokens (Untitled10)
- idx (Index) — PK — Primary key — NOT NULL
- user_idx (User Index) — FK — Foreign key → users.idx — NOT NULL
- device_token (Device Token (FCM/APNS))
- platform (Platform) — 0=web; 1=android; 2=ios
- device_id (Device ID)
- device_name (Device Name)
- app_version (Application Version)
- is_active (Account Active)
- last_used_at (Last Active Date)
- Field
user_images (Untitled7)
- idx (Index) — PK — Primary key — NOT NULL
- user_idx (User Index) — FK — Foreign key → users.idx — NOT NULL
- image (Image)
- created_at (Created Date)
- updated_at (Updated Date)
user_lifestyles (Untitled8)
- idx (Index) — PK — Primary key — NOT NULL
- user_idx (User Index) — FK — Foreign key → users.idx — NOT NULL
- category_sub_lifestyles (Lifestyle Subcategories)
user_linkedin_verifies (Untitled6)
- idx (Index) — PK — Primary key — NOT NULL
- user_idx (User Index) — FK — Foreign key → users.idx — NOT NULL
- email (Email)
- created_at (Created Date)
user_notification_settings (Untitled9)
- idx (Index) — PK — Primary key — NOT NULL
- user_idx (User Index) — FK — Foreign key → users.idx — NOT NULL
- is_push (Notify Push) — 0=Not notify; 1=Notify
- is_email (Notify Email) — 0=Not notify; 1=Notify
- is_message (Notify Message) — 0=Not notify; 1=Notify
- is_room_updated (Notify Room Update) — 0=Not notify; 1=Notify
- is_community (Notify Community Update) — 0=Not notify; 1=Notify
- is_same_gender (Notify Same Gender Only) — 0=Not notify; 1=Notify
- is_agent_message (Notify Agent Message) — 0=Not notify; 1=Notify
- is_same_school (Notify Same School Only) — 0=Not notify; 1=Notify
- is_similar_age_message (Notify Similar Age Only) — 0=Not notify; 1=Notify
- created_at (Created Date)
- updated_at (Updated Date)
user_passwords (Untitled4)
- idx (Index) — PK — Primary key — NOT NULL
- user_idx (User Index) — FK — Foreign key → users.idx — NOT NULL
- password (Password) — AES Encrypt
- created_at (Created Date)
- updated_at (Updated Date)
user_privacy_settings (Untitled3)
- idx (Index) — PK — Primary key — NOT NULL
- user_idx (User Index) — FK — Foreign key → users.idx — NOT NULL
- is_firstname (Display Firstname) — 0_Not displayed; 1_Displayed
- is_area (Display Area) — 0_Not displayed; 1_Displayed
- is_age (Display Age) — 0_Not displayed; 1_Displayed
- is_pronouns (Display Pronouns) — 0_Not displayed; 1_Displayed
- is_major (Display Major) — 0_Not displayed; 1_Displayed
- is_school_year (Display School Year) — 0_Not displayed; 1_Displayed
- created_at (Created Date)
- updated_at (Updated Date)
user_school_verifies (Untitled5)
- idx (Index) — PK — Primary key — NOT NULL
- user_idx (User Index) — FK — Foreign key → users.idx — NOT NULL
- email (Email)
- created_at (Created Date)
users (Untitled)
- idx (Index) — PK — Primary key — NOT NULL
- email (Email)
- sns_type (Account Type) — 0=Email, 1=Google, 2=Apple
- user_type (User Type) — 0=General, 1=Agent, 99=Admin
- first_name (First Name) — AES Encrypt
- last_name (Last Name) — AES Encrypt
- birth_date (Birth Date) — AES Encrypt
- gender (Gender) — 0=Male, 1=Female, 2=Others
- job_type (Job) — 0=Student; 1=Working; 2=Others
- bio (Bio)
- major (Major)
- school_year (School Year)
- company (Company)
- position (Job Position)
- created_at (Created Date)
- updated_at (Updated Date)
- is_active (Account Active)
zips (Untitled11)
- idx (Index) — PK — Primary key — NOT NULL
- user_idx (User Index) — FK — Foreign key → users.idx — NOT NULL
- code (Zip Code)
- area (Area) — AES Encrypt
- neighborhood (Neighborhood) — AES Encrypt