bio-profit-loss-test
Tables (4)
admin_user
- id — char(36) — Primary key — NOT NULL
- is_withdrawal — tinyint(1) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp — NOT NULL
- role — tinyint — NOT NULL
- phone_no — varchar(30) — NOT NULL
- register_service — varchar(30) — NOT NULL
- account — varchar(50) — NOT NULL — 토큰이슈어 사용자 계정
- email — varchar(100)
- withdrawal_reason — varchar(100)
- name — varchar(30)
- memo — varchar(200)
admin_user_default_detail_role
- id — char(36) — Primary key — NOT NULL
- role — int — NOT NULL
- menu — int — NOT NULL
- read_role — int — NOT NULL
- update_role — int — NOT NULL
- delete_role — int — NOT NULL
- create_role — int — NOT NULL
admin_user_detail_role
- id — char(36) — Primary key — NOT NULL
- admin_user_id — char(36) — Foreign key → admin_user.id — NOT NULL
- menu — tinyint — NOT NULL
- read_role — tinyint — NOT NULL
- update_role — tinyint — NOT NULL
- delete_role — tinyint — NOT NULL
- create_role — tinyint — NOT NULL
submit (제출)
- id — char(36) — Primary key — NOT NULL
- role — int — NOT NULL
- menu — int — NOT NULL
- read_role — int — NOT NULL
- update_role — int — NOT NULL
- delete_role — int — NOT NULL
- create_role — int — NOT NULL