TheWhiteboard

Tables (4)

Board (boards)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • description (Field2) — varchar(250)
  • page_count (Field3) — int
  • created_at (Field4) — timestamp

Memo (memos)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → User.id — NOT NULL
  • board_id (FK2) — bigint — Foreign key → Board.id — NOT NULL
  • referenced_memo_id (FK3) — bigint
  • replied_memo_id (FK4) — bigint
  • memo_type (Field) — int
  • title (Field2) — string
  • content (Field3) — string
  • image_url_first (Field4) — varchar(250)
  • image_url_second (Field5) — varchar(250)
  • is_writing (Field6) — boolean
  • page (Field7) — int
  • position_x (Field8) — int
  • position_y (Field9) — int
  • created_at (Field10) — timestamp
  • updated_at (Field11) — timestamp

User (users)

  • id (Key) — bigint — Primary key — NOT NULL
  • oauth_id (Field) — bigint
  • nickname (Field2) — varchar(20)
  • created_at (Filed2) — timestamp
  • updated_at (Field3) — timestamp

Vote (votes)

  • id (Key) — bigint — Primary key — NOT NULL
  • memo_id (FK) — bigint — Foreign key → Memo.id — NOT NULL
  • user_id (FK2) — bigint — Foreign key → User.id — NOT NULL
  • is_up (Field) — boolean
  • created_at (Field2) — timestamp
  • updated_at (Field3) — timestamp