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