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