apartment
Tables (5)
Apartment (아파트)
- Apartment_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- email (apartment_id) — VARCHAR — Foreign key → User.email — NOT NULL
- name — VARCHAR
- address — VARCHAR
Comment (댓글)
- comment_id (Key) — BIGINT — Primary key — NOT NULL
- id (boards_id) — BIGINT — Foreign key → boards.id — NOT NULL
- user_id — BIGINT — Foreign key → boards.user_id — NOT NULL
- email (apartment_id) — BIGINT — Foreign key → boards.email — NOT NULL
- content (Field) — VARCHAR
- createdAt (Field2) — BIGINT
Employee (관리소직원)
- employee_id (Key) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → User.user_id — NOT NULL
- user_id (apartment_id) — BIGINT — Foreign key → User.email — NOT NULL
- employee_email (Field) — BIGINT
- employeeNumber (Field2) — VARCHAR
- role (Field3) — VARCHAR
User (사용자)
- user_id — BIGINT — Primary key — NOT NULL
- email (apartment_id) — VARCHAR — Primary key — NOT NULL
- usename (Field2) — BIGINT
boards (게시판)
- id (boards_id) — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- email (apartment_id) — BIGINT — Foreign key → User.email — NOT NULL
- title — VARCHAR
- content — VARCHAR
- category — VARCHAR
- created_date — DEFAULT CURRENT_TIMESTAMP