qwe

Tables (9)

article

  • article_id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • content — varchar(255)
  • title — varchar(255)
  • view_count — integer — NOT NULL
  • member_id (member_id2) — bigint — Foreign key → member.member_id — NOT NULL

article_image

  • id — bigint — Primary key — NOT NULL
  • origin_file_name — varchar(255)
  • upload_file_name — varchar(255)
  • article_id (article_id2) — bigint — Foreign key → article.article_id — NOT NULL

comment

  • comment_id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • content — varchar(255)
  • parent_id — bigint
  • member_id (member_id2) — bigint — Foreign key → member.member_id — NOT NULL
  • article_id (article_id2) — bigint — Foreign key → article.article_id — NOT NULL

gym

  • gym_id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • addr — varchar(255)
  • lat — double
  • lng — double
  • place — varchar(255)
  • member_id (member_id2) — bigint — Foreign key → member.member_id — NOT NULL

member

  • member_id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • detail_address — varchar(255)
  • road_name — varchar(255)
  • zipcode — varchar(255)
  • email — varchar(255) — NOT NULL
  • member_role — varchar(255)
  • nickname — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • phone — varchar(255)

my_workout

  • my_workout_id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • member_id — bigint
  • workout_id (workout_id2) — bigint — Foreign key → workout.workout_id — NOT NULL

record

  • record_id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • total — bigint — NOT NULL
  • workout_category — varchar(255) — NOT NULL
  • my_workout_id (my_workout_id2) — bigint — Foreign key → my_workout.my_workout_id — NOT NULL

workout

  • workout_id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • content — varchar(255) — NOT NULL
  • workout_category — varchar(255) — NOT NULL
  • workout_name — varchar(255) — NOT NULL
  • member_id (member_id2) — bigint — Foreign key → member.member_id — NOT NULL

workout_image

  • workout_image_id — bigint — Primary key — NOT NULL
  • origin_file_name — varchar(255) — NOT NULL
  • upload_file_name — varchar(255) — NOT NULL
  • workout_id (workout_id2) — bigint — Foreign key → workout.workout_id — NOT NULL