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