pass-web

Tables (3)

PackageEntity (package_entity)

  • PackageSeq (package_seq) — Int — Primary key — NOT NULL
  • PackageName (package_name) — VARCHAT(50)
  • PackageGym (package_gym) — Int
  • PackagePt (package_pt) — Int

PassEntity (pass_entity)

  • PassSeq (pass_seq) — Int — Primary key — NOT NULL
  • UserId (user_id) — VARCHAT(20) — Foreign key → UserEntity.UserId — NOT NULL
  • GymPeriod (gym_period) — Int
  • CountPt (count_pt) — Int
  • Status (status) — VARCHAT(15)
  • Field

UserEntity (user_entity)

  • UserId (user_id) — VARCHAT(20) — Primary key — NOT NULL
  • UserPassword (user_password) — VARCHAT(100)
  • Email (email) — VARCHAT(100)
  • Nickname (nickname) — VARCHAT(50)
  • Status (status) — EnumType
  • RoleTypes (role_types) — Set
  • Phone (phone) — VARCHAT(50)
  • Meta (meta) — String