ㅁ

Tables (6)

Answers

  • id — SERIAL
  • question_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Calendars

  • id — SERIAL
  • user_id — INT — NOT NULL
  • date — DATE — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(user_id, — date)

Logs

  • id — SERIAL
  • user_id — INT
  • action — VARCHAR(50) — NOT NULL
  • target_id — INT — NOT NULL
  • target_type — ENUM('Question', 'Answer') — NOT NULL
  • timestamp — TIMESTAMP

Questions

  • id — SERIAL
  • calendar_id — INT — NOT NULL
  • user_id — INT
  • nickname — VARCHAR(50)
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Shares

  • id — SERIAL
  • question_id — INT
  • answer_id — INT
  • platform — VARCHAR(50) — NOT NULL
  • shared_by — INT — NOT NULL
  • shared_at — TIMESTAMP

Users

  • id — SERIAL
  • username — VARCHAR(50)
  • email — VARCHAR(100)
  • password — VARCHAR(255)
  • profile_picture — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP