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