ㅁㄴㅇ

Tables (12)

bookmarks

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • post_id — INTEGER — NOT NULL
  • created_at — TIMESTAMP

categories

  • id — SERIAL
  • name — VARCHAR(25) — NOT NULL
  • slug — VARCHAR(200) — NOT NULL
  • is_public — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

comment_likes

  • comment_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Primary key — NOT NULL

comments

  • id — SERIAL
  • post_id — INTEGER — NOT NULL
  • author_id — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • parent_comment_id — INTEGER

notifications

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

post_likes

  • post_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Primary key — NOT NULL

post_tags

  • post_id — INTEGER — Primary key — NOT NULL
  • tag_id — INTEGER — Primary key — NOT NULL

posts

  • id — SERIAL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • head_image — VARCHAR(255)
  • file_upload — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • author_id — INTEGER — NOT NULL
  • category_id — INTEGER
  • view_count — INTEGER
  • birthday — DATE
  • location — VARCHAR(100)

profile_followers

  • profile_id — INTEGER — Primary key — NOT NULL
  • follower_id — INTEGER — Primary key — NOT NULL

profiles

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • bio — TEXT
  • location — VARCHAR(30)
  • birth_date — DATE
  • profile_picture — VARCHAR(255)

tags

  • id — SERIAL
  • name — VARCHAR(50) — NOT NULL
  • slug — VARCHAR(100) — NOT NULL

users

  • id — SERIAL
  • username — VARCHAR(150) — NOT NULL
  • email — VARCHAR(254)
  • password — VARCHAR(128) — NOT NULL