PRACTICE_ERD2
Tables (14)
APT_UNIT
- apt_id — BIGINT
- apt_name — VARCHAR(50)
- dong — INT
- hosu — INT
- apt_code — VARCHAR(100)
ARTICLE
- article_num — BIGINT
- user_id — BIGINT
- title — VARCHAR(255)
- content — TEXT
- hashtag — VARCHAR(255)
- created_at — DATETIME
- modified_at — DATETIME
COMMENT
- comment_id — BIGINT
- article_num — BIGINT
- user_id — BIGINT
- content — TEXT
- created_at — DATETIME
- modified_at — DATETIME
KNOCK_REQUEST
- request_id — BIGINT
- requester_id — BIGINT
- request_time — DATETIME
- noise_category — VARCHAR(30)
- notification_scope — UNSPECIFIED
KNOCK_RESPONSE
- response_id — BIGINT
- requester_id — BIGINT
- request_id — BIGINT
- response_type — VARCHAR(30)
- response_time — DATETIME
MANAGER
- office_id — BIGINT
- apt_name — VARCHAR(50)
- phone_num — VARCHAR(20)
- created_at — UNSPECIFIED
MONTHLY_NOISE_REPORT
- report_id — BIGINT
- apt_id — BIGINT
- report_month — DATE
- total_log_count — INT
- rate_of_change — DECIMAL(5,2)
- peak_time — INT
- created_at — DATETIME
NOISE_LOG
- log_id — BIGINT
- user_id — BIGINT
- log_datetime — DATETIME
- noise_type — VARCHAR(30)
- noise_level — INT
- memo — DATETIME
NOISE_TIME
- time_id — BIGINT
- report_id — BIGINT
- field1 — UNSPECIFIED
- field2 — UNSPECIFIED
- field3 — UNSPECIFIED
NOISE_TYPE
- type_id — BIGINT
- report_id — BIGINT
- noise_type — VARCHAR(30)
- log_count — INT
- percentage — DECIMAL(5,2)
POINTS_LOG
- log_id — BIGINT
- user_id — BIGINT
- points_gained — INT
- activity_type — VARCHAR(50)
- activity_detail — VARCHAR(255)
- activity_date — DATETIME
PRE_NOTICE
- notice_id — BIGINT
- writer_id — BIGINT
- title — VARCHAR(100)
- content — TEXT
- post_date — DATETIME
- post_time — DATETIME
TRUST_INDEX
- index_id — BIGINT
- user_id — BIGINT
- total_score — INT
- grade — VARCHAR(30)
- noise_care_score — INT
- communication_score — INT
- consideration_score — INT
- compliance_score — INT
- updated_at — DATETIME
USER
- user_id — BIGINT
- apt_id — BIGINT
- email — VARCHAR(50)
- points — INT
- trust_index — INT
- created_at — DATETIME
- modified_at — DATETIME