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