apartment

Tables (4)

Apartment (아파트)

  • id_apartment (id) — BIGINT — Primary key — NOT NULL
  • name — varchar
  • address — varchar
  • created_date — DATETIME
  • modified_date — DATETIME
  • removed_date — DATETIME

Comment (댓글)

  • id_comment (Key) — BIGINT — Primary key — NOT NULL
  • id_user (id) — BIGINT — Foreign key → User.id_user — NOT NULL
  • id_post (id3) — BIGINT — Foreign key → Post.id_post — NOT NULL
  • id_apartment (id2) — BIGINT — Foreign key → User.id_apartment — NOT NULL
  • content (Field) — varchar
  • created_date (Field2) — DATETIME
  • modified_date (Field3) — DATETIME
  • removed_date (Field4) — DATETIME
  • post_id (Field5) — BIGINT
  • user_id (Field6) — BIGINT

Post (게시판)

  • id_post (id) — BIGINT — Primary key — NOT NULL
  • id_user (id2) — BIGINT — Foreign key → User.id_user — NOT NULL
  • id_apartment (id22) — BIGINT — Foreign key → User.id_apartment — NOT NULL
  • title — varchar
  • content — varchar
  • created_date — DATETIME
  • modified_date — DATETIME
  • removed_date — DATETIME
  • user_id — BIGINT
  • apartment_id — BIGINT
  • category (Field) — varchar

User (사용자)

  • id_user (id) — BIGINT — Primary key — NOT NULL
  • id_apartment (id2) — BIGINT — Foreign key → Apartment.id_apartment — NOT NULL
  • user_id — varchar
  • password — varchar
  • created_date — DATETIME
  • modified_date — DATETIME
  • removed_date — DATETIME
  • role — varchar
  • apartment_id — BIGINT