OpusDB

Tables (6)

comment_likes

  • member_id — INT — Primary key — NOT NULL
  • comment_id — INT — Primary key — NOT NULL
  • status — VARCHAR(10)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

comments

  • comment_id — INT
  • post_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

member

  • member_id — INT
  • username — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

pin_likes

  • member_id — INT — Primary key — NOT NULL
  • pin_id — INT — Primary key — NOT NULL
  • status — VARCHAR(10)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

pins

  • pin_id — INT
  • member_id — INT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

tokens

  • r_key — INT — Primary key — NOT NULL
  • r_value — VARCHAR(255)