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