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