JAMMIN

Tables (7)

boards (board)

  • Key (id) — Long — Primary key — NOT NULL
  • Field1 (title) — varchar — NOT NULL
  • Field2 (username) — varchar — NOT NULL
  • Field7 (background_color) — varchar
  • Field3 (status) — boolean — NOT NULL
  • 생성날짜 (created_at) — LocalDateTime — NOT NULL
  • 수정날짜 (modified_at) — LocalDateTime — NOT NULL

card_collaborators (CardCollaborators)

  • Key (Key2) — Long — Foreign key → cards.Key — NOT NULL
  • Key — Long — Foreign key → member.Key — NOT NULL

cards (card)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (column_id) — Long — Foreign key → catalogs.Key — NOT NULL
  • Field1 (tilte) — varchar — NOT NULL
  • Field2 (username) — varchar — NOT NULL
  • Field3 (description) — varchar
  • Field10 (background_color) — varchar
  • Field9 (status) — boolean
  • Field8 (start_day) — Timestamp
  • Field7 (due_day) — Timestamp — NOT NULL
  • Field (position) — Long — NOT NULL
  • 생성날짜 (created_at) — Timestamp — NOT NULL
  • 수정날짜 (modified_at) — Timestamp — NOT NULL
  • Field (image_url) — varchar

catalogs (column)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (board_id) — Long — Foreign key → boards.Key — NOT NULL
  • Field1 (title) — varchar — NOT NULL
  • Field2 (status) — boolean — NOT NULL
  • 생성날짜 (created_at) — Timestamp — NOT NULL
  • 수정날짜 (modified_at) — Timestamp — NOT NULL
  • Field (position) — Long — NOT NULL

comments (comment)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (card_id) — Long — Foreign key → cards.Key — NOT NULL
  • Key (user_id) — Long — Foreign key → member.Key — NOT NULL
  • Field2 (content) — varchar — NOT NULL
  • 생성날짜 (created_at) — Timestamp — NOT NULL
  • 수정날짜 (modified_at) — Timestamp — NOT NULL

member (user)

  • Key (id) — Long — Primary key — NOT NULL
  • 아이디 (username) — varchar — NOT NULL
  • 비밀번호 (password) — varchar(255) — NOT NULL
  • 닉네임 (nickname) — varchar — NOT NULL
  • 이메일 (email) — varchar — NOT NULL
  • 생성날짜 (created_at) — LocalDateTime — NOT NULL
  • 수정날짜 (modified_at) — Timestamp — NOT NULL

user_board (UserBoard)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (user_id) — Long — Foreign key → member.Key — NOT NULL
  • Key (board_id) — Long — Foreign key → boards.Key — NOT NULL
  • Field (role) — varchar — NOT NULL