SoonNyang

Tables (11)

authority

  • authority_name — VARCHAR(50) — Primary key — NOT NULL

cat

  • cat_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • age — VARCHAR(255)
  • gender — VARCHAR(255)
  • follower_cnt — BIGINT
  • image_url — VARCHAR(255)
  • is_active — VARCHAR(255) — NOT NULL
  • tnrdate — date

disease (CopyOfdisease_timeline)

  • disease_id — Primary key — NOT NULL
  • name — VARCHAR(50)
  • explanation — VARCHAR(500)

disease_timeline

  • disease_timeline_id — Primary key — NOT NULL
  • disease_id — Foreign key → disease.disease_id — NOT NULL
  • cat_id — BIGINT — Foreign key → cat.cat_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • image_url — VARCHAR(500)
  • created_at (Field3) — datetime

feedspot (Untitled3)

  • feedspot_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • description — VARCHAR(50)
  • image_url — VARCHAR(255)
  • latitude — DOUBLE
  • longitude — DOUBLE

follow (Untitled2)

  • follow_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • cat_id — BIGINT — Foreign key → cat.cat_id — NOT NULL

member

  • member_id — BIGINT — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime
  • deleted_at — datetime
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255)
  • introduction — VARCHAR(100)

member_authority

  • authority_name — VARCHAR(50) — Foreign key → authority.authority_name — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL

post

  • post_id — BIGINT — Primary key — NOT NULL
  • cat_id — BIGINT — Foreign key → cat.cat_id
  • member_id — BIGINT — Foreign key → member.member_id
  • latitude — DOUBLE
  • longitude — DOUBLE
  • content — VARCHAR(255)
  • image — VARCHAR(255)
  • like_count — BIGINT
  • created_at — datetime — NOT NULL
  • modified_at — datetime
  • deleted_at — datetime

postLike (Untitled)

  • post_like_id (Key) — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL

post_image

  • post_image_id — BIGINT — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime
  • deleted_at — datetime
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL
  • original_file_name — VARCHAR(255)
  • image_url — VARCHAR(500) — NOT NULL