member
Tables (3)
Address (User_Address)
- Key (user_pk) — BigInt — Foreign key → Member.Key — NOT NULL
- Postcode (user_postcode) — varchar(10)
- Country (user_country) — varchar(100)
- city (user_city) — varchar(255)
- detail_address (user_detail_address) — varchar(255)
Login (User_Login)
- Key (user_uuid) — varchar(255) — Primary key — NOT NULL
- Key (user_pk) — BigInt — Foreign key → Member.Key — NOT NULL
- refreshtoken (user_refreshtoken) — varchar(255)
- expired_at (user_expired_at) — DateTime
Member (User)
- Key (user_pk) — BigInt — Primary key — NOT NULL
- role (user_role) — enum
- email (user_email) — varchar(255)
- id (user_id) — varchar(255)
- password (user_password) — varchar(128)
- name (user_name) — varchar(20)
- phone_number (user_phone_number) — varchar(15)
- emergency_number (user_emergency_number) — varchar(15)
- created_at (user_created_at) — DateTime
- updated_at (user_updated_at) — DateTime
- is_deleted (user_is_deleted) — boolean
- deleted_at (user_deleted_at) — DateTime
- last_login (user_last_login) — DateTime
- last_logout (user_last_logout) — DateTime