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