apartment

Tables (8)

Untitled (apartments)

  • Key (apartment_id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (address) — varcher
  • Field3 (name) — varcher
  • Field (email) — varcher

Untitled (boards)

  • Key (board_id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (cetegory) — varcher
  • Field2 (content) — varcher
  • Field3 (created_date) — DateTime
  • Field (title) — varcher
  • Field (board_status) — Enum

Untitled (comments)

  • Key (comment_id) — bigint — Primary key — NOT NULL
  • Key (board_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — varcher
  • Field2 (cratedAt) — DateTime
  • Field3 (comment_status) — Enum

Untitled (employees)

  • Key (employee_id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (employeeNumber) — varcher
  • Field2 (email) — String

Untitled (board_status)

  • Key (board_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (ACTIVE) — Enum
  • Field2 (DELETED) — Enum

Untitled (comment_status)

  • Key (comment_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (board_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (ACTIVE) — Enum
  • Field2 (DELETED) — Enum

Untitled (users_status)

  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (ACTIVE) — Enum
  • Field2 (DELETED) — Enum

User (users)

  • Key (user_id) — bigint — Primary key — NOT NULL
  • username — varcher
  • Field2 (password) — varcher
  • Field3 (email) — varcher
  • Field4 (role) — Enum
  • Field (loginType) — Enum
  • Field2 (created_date) — LocalDateTime
  • Field5 (users_status) — Enum