voyager
Tables (19)
data_rows
- id — int
- data_type_id — int — NOT NULL
- field — varchar(255) — NOT NULL
- type — varchar(255) — NOT NULL
- display_name — varchar(255) — NOT NULL
- required — tinyint(1) — NOT NULL
- browse — tinyint(1) — NOT NULL
- read — tinyint(1) — NOT NULL
- edit — tinyint(1) — NOT NULL
- add — tinyint(1) — NOT NULL
- delete — tinyint(1) — NOT NULL
- details — text
- order — int — NOT NULL
data_types
- id — int
- name — varchar(255) — NOT NULL
- slug — varchar(255) — NOT NULL
- display_name_singular — varchar(255) — NOT NULL
- display_name_plural — varchar(255) — NOT NULL
- icon — varchar(255)
- model_name — varchar(255)
- policy_name — varchar(255)
- controller — varchar(255)
- description — varchar(255)
- generate_permissions — tinyint(1) — NOT NULL
- server_side — tinyint — NOT NULL
- details — text
- created_at — timestamp
- updated_at — timestamp
failed_jobs
- id — bigint
- connection — text — NOT NULL
- queue — text — NOT NULL
- payload — longtext — NOT NULL
- exception — longtext — NOT NULL
- failed_at — timestamp — NOT NULL
menu_items
- id — int
- menu_id — int
- title — varchar(255) — NOT NULL
- url — varchar(255) — NOT NULL
- target — varchar(255) — NOT NULL
- icon_class — varchar(255)
- color — varchar(255)
- parent_id — int
- order — int — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- route — varchar(255)
- parameters — text
menus
- id — int
- name — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
migrations
- id — int
- migration — varchar(255) — NOT NULL
- batch — int — NOT NULL
oauth_access_tokens
- id — varchar(100) — NOT NULL
- user_id — bigint
- client_id — int — NOT NULL
- name — varchar(255)
- scopes — text
- revoked — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- expires_at — datetime
oauth_auth_codes
- id — varchar(100) — NOT NULL
- user_id — bigint — NOT NULL
- client_id — int — NOT NULL
- scopes — text
- revoked — tinyint(1) — NOT NULL
- expires_at — datetime
oauth_clients
- id — int
- user_id — bigint
- name — varchar(255) — NOT NULL
- secret — varchar(100)
- redirect — text — NOT NULL
- personal_access_client — tinyint(1) — NOT NULL
- password_client — tinyint(1) — NOT NULL
- revoked — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
oauth_personal_access_clients
- id — int
- client_id — int — NOT NULL
- created_at — timestamp
- updated_at — timestamp
oauth_refresh_tokens
- id — varchar(100) — NOT NULL
- access_token_id — varchar(100) — NOT NULL
- revoked — tinyint(1) — NOT NULL
- expires_at — datetime
password_resets
- email — varchar(255) — NOT NULL
- token — varchar(255) — NOT NULL
- created_at — timestamp
permission_role
- id (permission_id) — bigint — Foreign key → permissions.id — NOT NULL
- 역할ID (role_id) — bigint — Foreign key → roles.역할ID — NOT NULL
permissions
- id — bigint — Primary key — NOT NULL
- key — varchar(255) — NOT NULL
- table_name — varchar(255)
- created_at — timestamp
- updated_at — timestamp
roles
- 역할ID (id) — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- display_name — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
settings
- id — int
- key — varchar(255) — NOT NULL
- display_name — varchar(255) — NOT NULL
- value — text
- details — text
- type — varchar(255) — NOT NULL
- order — int — NOT NULL
- group — varchar(255)
translations
- id — int
- table_name — varchar(255) — NOT NULL
- column_name — varchar(255) — NOT NULL
- foreign_key — int — NOT NULL
- locale — varchar(255) — NOT NULL
- value — text — NOT NULL
- created_at — timestamp
- updated_at — timestamp
user_roles
- 사용자ID (user_id) — bigint — Foreign key → users.사용자ID — NOT NULL
- 역할ID (role_id) — bigint — Foreign key → roles.역할ID — NOT NULL
users
- 사용자ID (id) — Primary key — NOT NULL
- 역할ID (role_id) — bigint — Foreign key → roles.역할ID — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- avatar — varchar(255)
- email_verified_at — timestamp
- password — varchar(255) — NOT NULL
- remember_token — varchar(100)
- settings — text
- created_at — timestamp
- updated_at — timestamp