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