membership-amazon

Tables (8)

Untitled (cities)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field (description) — NOT NULL
  • Field (keyword) — NOT NULL
  • Field (detail) — NOT NULL
  • Field (image_path) — NOT NULL

Untitled (countries)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field (color) — NOT NULL

Untitled (countries_cities)

  • Key (city_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Key (country_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL

accounts

  • id — NOT NULL — Primary key — NOT NULL
  • email — NOT NULL
  • password (password_key) — NOT NULL
  • Field (salt) — NOT NULL

permissions

  • id — NOT NULL — Primary key — NOT NULL
  • Field (type) — NOT NULL

users

  • id — NOT NULL — Primary key — NOT NULL
  • name — NOT NULL

users_accounts

  • user_id (account_id) — NOT NULL — Foreign key → accounts.id — NOT NULL
  • id (user_id) — NOT NULL — Foreign key → users.id — NOT NULL

users_permissions (user_permissions)

  • id (user_id) — NOT NULL — Foreign key → users.id — NOT NULL
  • Key (permission_id) — NOT NULL — Foreign key → permissions.id — NOT NULL