Reflect

Tables (5)

member (Untitled)

  • id (Key) — long — Primary key — NOT NULL
  • email (Field2) — varchar(255) — NOT NULL
  • password (Field3) — varchar(512) — NOT NULL
  • name (Field) — varchar(20) — NOT NULL
  • created_at (Field4) — timestamp — NOT NULL
  • updated_at (Field5) — timestamp — NOT NULL
  • is_deleted (Field6) — boolean — NOT NULL

question (Untitled2)

  • id (Key) — long — Primary key — NOT NULL
  • category_id (Key2) — long — Foreign key → question_category.id — NOT NULL
  • content (Field) — varchar(200) — NOT NULL
  • created_at (Field2) — timestamp — NOT NULL
  • updated_at (Field3) — timestamp — NOT NULL
  • is_deleted (Field4) — boolean — NOT NULL

question_answer (Untitled3)

  • id (Key) — long — Primary key — NOT NULL
  • member_id (Key2) — long — Foreign key → member.id — NOT NULL
  • question_id (Key3) — long — Foreign key → question.id — NOT NULL
  • content (Field) — text — NOT NULL
  • is_private (Field5) — boolean — NOT NULL
  • created_at (Field2) — timestamp — NOT NULL
  • updated_at (Field3) — timestamp — NOT NULL
  • is_deleted (Field4) — boolean — NOT NULL

question_answer_like (Untitled4)

  • id (Key) — long — Primary key — NOT NULL
  • member_id (Key2) — long — Foreign key → member.id — NOT NULL
  • question_answer_id (Key3) — long — Foreign key → question_answer.id — NOT NULL
  • created_at (Field) — timestamp — NOT NULL
  • updated_at (Field2) — timestamp — NOT NULL
  • is_deleted (Field3) — boolean — NOT NULL

question_category (Untitled5)

  • id (Key) — long — Primary key — NOT NULL
  • category_name (Field) — varchar(50) — NOT NULL
  • created_at (Field2) — timestamp — NOT NULL
  • updated_at (Field3) — timestamp — NOT NULL
  • is_deleted (Field4) — boolean — NOT NULL