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