fit-too
Tables (6)
ExerciseType (Untitled5)
- id (Key) — BIGINT — Primary key — NOT NULL
Member (Untitled)
- id — BIGINT — Primary key — NOT NULL
- userId (Field) — VARCHAR(50) — NOT NULL
- password (Field2) — VARCHAR(50) — NOT NULL
- phone (Field3) — VARCHAR(20) — NOT NULL
- gender (Field4) — INT — NOT NULL
- member_type (Field5) — INT — NOT NULL
- exercise_period (Field8) — VARCHAR(255)
- reg_purpose (Field6) — VARCHAR(200) — NOT NULL
- power (Field7) — INT
- point (Field9) — BIGINT
- reg_dt (Field10) — DATE — NOT NULL
- udt_dt (Field11) — DATE — NOT NULL
Reservation (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- member_id (2) — BIGINT — Foreign key → Member.id — NOT NULL
- trainer_id (3) — BIGINT — Foreign key → Trainer.id — NOT NULL
- id (Key2) — BIGINT — Foreign key → Trainer.id — NOT NULL
- reservationDt (Field) — DATE — NOT NULL
- region (Field2) — VARCHAR(255) — NOT NULL
- member_name (Field3) — VARCHAR(50) — NOT NULL
- trainer_name (Field4) — VARCHAR(50) — NOT NULL
Review (Untitled3)
- id (Key) — BIGINT — Primary key — NOT NULL
- member_id (2) — BIGINT — Foreign key → Member.id — NOT NULL
- trainer_id (3) — BIGINT — Foreign key → Trainer.id — NOT NULL
- id (Key2) — BIGINT — Foreign key → Trainer.id — NOT NULL
- comment (Field) — VARCHAR(255) — NOT NULL
- score (Field4) — INT — NOT NULL
- regDt (Field2) — DATE — NOT NULL
- udtDt (Field3) — DATE
Schedule (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- trainer_id (2) — BIGINT — Foreign key → Trainer.id — NOT NULL
- id (Key2) — BIGINT — Foreign key → Trainer.id — NOT NULL
- comment (Field) — VARCHAR(255)
- excludeDate (Field2) — DATE — NOT NULL
Trainer (CopyOfUntitled)
- id — BIGINT — Primary key — NOT NULL
- id (Key) — BIGINT — Foreign key → ExerciseType.id — NOT NULL
- userId (Field) — VARCHAR(50) — NOT NULL
- password (Field2) — VARCHAR(50) — NOT NULL
- phone (Field3) — VARCHAR(20) — NOT NULL
- gender (Field4) — INT — NOT NULL
- login_type (Field5) — INT — NOT NULL
- exercise_period (Field8) — VARCHAR(255)
- main (Field6) — VARCHAR(200) — NOT NULL
- awards (Field9) — VARCHAR(255)
- main_pt_list (Field10) — VARCHAR(255) — NOT NULL
- profile_picture_new_name (Field11) — VARCHAR(255) — NOT NULL
- profile_picture_ori_name (Field12) — VARCHAR(255) — NOT NULL
- region (Field13) — VARCHAR(255) — NOT NULL
- introduce (Field14) — VARCHAR(255)
- reg_dt (Field15) — DATE — NOT NULL
- udt_dt (Field16) — DATE
- price (Field7) — BIGINT — NOT NULL
- totalScore (Field17) — INT
- id (2) — BIGINT — Foreign key → Trainer.id — NOT NULL
- id (Key2) — BIGINT — Foreign key → Trainer.id — NOT NULL