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