sa
Tables (6)
article
- article_id — BIGINT — Primary key — NOT NULL
- created_date — datetime
- modified_date — datetime
- title — VARCHAR(255)
- content — VARCHAR(255)
- member_id — BIGINT — Foreign key → member.member_id
- file_path — VARCHAR(255)
- view_count — INT — NOT NULL
- like_count — INT — NOT NULL
comment
- comment_id — BIGINT — Primary key — NOT NULL
- created_date — datetime
- modified_date — datetime
- member_id — BIGINT — Foreign key → member.member_id
- content — VARCHAR(255)
- parent_id — BIGINT — Foreign key → comment.comment_id
member
- member_id — BIGINT — Primary key — NOT NULL
- created_date — datetime
- modified_date — datetime
- email — VARCHAR(255)
- password — VARCHAR(255)
- name — VARCHAR(255)
- phone — VARCHAR(255)
- city — VARCHAR(255)
- road_name — VARCHAR(255)
- zipcode — VARCHAR(255)
recommend
- recommend_id — BIGINT — Primary key — NOT NULL
- article_id — BIGINT — Foreign key → article.article_id
- member_id — BIGINT — Foreign key → member.member_id
workout
- workout_id — BIGINT — Primary key — NOT NULL
- created_date — datetime
- modified_date — datetime
- content — VARCHAR(255)
- file_path — VARCHAR(255)
- category_id — BIGINT — Foreign key → workout_category.category_id — NOT NULL
workout_category
- category_id — BIGINT — Primary key — NOT NULL
- part — VARCHAR(255)
- parent_id — BIGINT — Foreign key → workout_category.category_id