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