lifegram

Tables (4)

Comment (Untitled3)

  • PK (id) — BIGINT — Primary key — NOT NULL
  • FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
  • FK (post_id) — BIGINT — Foreign key → Post.PK — NOT NULL
  • 댓글내용 (content) — VARCHAR(256)
  • 생성 (created_at) — TIMESTAMP
  • 업데이트 (updated_at) — TIMESTAMP

Like (Untitled4)

  • PK (id) — BIGINT — Primary key — NOT NULL
  • FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
  • FK (post_id) — BIGINT — Foreign key → Post.PK — NOT NULL

Post (Untitled2)

  • PK (id) — BIGINT — Primary key — NOT NULL
  • FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
  • 내용 (content) — VARCHAR(1024)
  • 이미지URL (img_url) — VARCHAR(255)
  • 생성 (created_at) — TIMESTAMP
  • 업데이트 (updated_at) — TIMESTAMP

User (Untitled)

  • PK (id) — BIGINT — Primary key — NOT NULL
  • 유저이름 (user_name) — VARCHAR(32)
  • 이메일 (email) — VARCHAR(256)
  • 패스워드 (password) — VARCHAR(256)
  • 이미지URL (img_url) — VARCHAR(256)
  • 생성 (created_at) — TIMESTAMP
  • 업데이트 (updated_at) — TIMESTAMP