팀프로젝트 ERD

테이블 (12)

ALARM (알람)

  • ALARM_NO (Key) — VARCHAR2(10) — 기본 키 — NOT NULL
  • ALARM_DATE (Field2) — DATE
  • ALARM_DAY (Field)
  • ALARM_HOUR (Field3)
  • MEM_ID (Key2) — VARCHAR2(20) — 외래 키 → MEMBER.MEM_ID — NOT NULL

AREA (지자체 지역)

  • AREA_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • PARENT_AREA_ID (Field2) — NUMBER
  • AREA_CODE (Field3) — VARCHAR2(50 BYTE)
  • AREA_NAME (Field4) — VARCHAR2(100 BYTE)
  • AREA_TYPE (Field5) — VARCHAR2(30 BYTE)
  • POSTAL_CODE (Field6) — VARCHAR2(10 BYTE)
  • CREATED_AT (Field7) — TIMESTAMP(6)
  • UPDATED_AT (Field8) — TIMESTAMP(6)
  • MUNICIPALITY_ID (Key2) — NUMBER — 외래 키 → MUNICIPALITY.MUNICIPALITY_ID — NOT NULL

COLLECTION_SCHEDULE (지자체/지역별 수거일정)

  • SCHEDULE_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • DAY_OF_WEEK (Field4) — VARCHAR2(30 BYTE)
  • WEEK_PATTERN (Field5) — VARCHAR2(30 BYTE)
  • COLLECTION_TIME_LIMIT (Field6) — TIMESTAMP(6)
  • EFFECTIVE_FROM (Field7) — DATE
  • EFFECTIVE_TO (Field8) — DATE
  • NOTES (Field9) — VARCHAR2(2000 BYTE)
  • SOURCE_ID (Field10) — NUMBER
  • CREATED_AT (Field11) — TIMESTAMP(6)
  • UPDATED_AT (Field12) — TIMESTAMP(6)
  • MUNICIPALITY_ID (Key2) — NUMBER — 외래 키 → MUNICIPALITY.MUNICIPALITY_ID — NOT NULL
  • AREA_ID (Key3) — NUMBER — 외래 키 → AREA.AREA_ID — NOT NULL
  • CATEGORY_ID (Key4) — NUMBER — 외래 키 → WASTE_CATEGORY.CATEGORY_ID — NOT NULL

COMMUNITY (커뮤니티)

  • COMMUNITY_NO (Key) — VARCHAR2(10) — 기본 키 — NOT NULL
  • COMMUNITY_TITLE (Field2) — VARCHAR2(100)
  • COMMUNITY_CONTENT (Field3) — VARCHAR2(2000)
  • COMMUNITY_ATTACH (Field4) — VARCHAR2(50)
  • COMMUNITY_REGDATE (Field6) — DATE
  • MEM_ID (Key2) — VARCHAR2(20) — 외래 키 → MEMBER.MEM_ID — NOT NULL

COMMUNITY_COMMENT (댓글)

  • COMMENT_NO (Key) — VARCHAR2(10) — 기본 키 — NOT NULL
  • COMMENT_CONTENT (Field3) — VARCHAR2(2000)
  • COMMENT_REGDATE (Field4) — DATE
  • COMMUNITY_NO (Key2) — VARCHAR2(10) — 외래 키 → COMMUNITY.COMMUNITY_NO — NOT NULL
  • MEM_ID (Key3) — 외래 키 → MEMBER.MEM_ID — NOT NULL

DISPOSAL_RULE (지자체별 배출 규칙)

  • RULE_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • DISPOSAL_METHOD (Field5) — VARCHAR2(200 BYTE)
  • DISPOSAL_LOCATION (Field6) — VARCHAR2(300 BYTE)
  • INSTRUCTION (Field7) — VARCHAR2(2000 BYTE)
  • CAUTION (Field8) — VARCHAR2(2000 BYTE)
  • IS_COLLECTABLE (Field9) — NUMBER(1,0)
  • EFFECTIVE_FROM (Field10) — DATE
  • EFFECTIVE_TO (Field11) — DATE
  • SOURCE_ID (Field12) — NUMBER
  • CREATED_AT (Field13) — TIMESTAMP(6)
  • UPDATED_AT (Field14) — TIMESTAMP(6)
  • MUNICIPALITY_ID (Key2) — NUMBER — 외래 키 → MUNICIPALITY.MUNICIPALITY_ID — NOT NULL
  • AREA_ID (Key3) — NUMBER — 외래 키 → AREA.AREA_ID — NOT NULL
  • ITEM_ID (Key4) — NUMBER — 외래 키 → WASTE_ITEM.ITEM_ID — NOT NULL
  • CATEGORY_ID (Key5) — NUMBER — 외래 키 → WASTE_CATEGORY.CATEGORY_ID — NOT NULL

FEE (지자체별 요금)

  • FEE_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • FEE_TYPE (Field3) — VARCHAR2(50 BYTE)
  • AMOUNT (Field4) — NUMBER(10,0)
  • CURRENCY (Field5) — VARCHAR2(3 BYTE)
  • UNIT (Field6) — VARCHAR2(50 BYTE)
  • CONDITION_DESCRIPTION (Field7) — VARCHAR2(2000 BYTE)
  • EFFECTIVE_FROM (Field8) — DATE
  • EFFECTIVE_TO (Field9) — DATE
  • SOURCE_ID (Field10) — NUMBER
  • CREATED_AT (Field11) — TIMESTAMP(6)
  • UPDATED_AT (Field12) — TIMESTAMP(6)
  • MUNICIPALITY_ID (Key2) — NUMBER — 외래 키 → MUNICIPALITY.MUNICIPALITY_ID — NOT NULL
  • ITEM_ID (Key3) — NUMBER — 외래 키 → WASTE_ITEM.ITEM_ID — NOT NULL

MEMBER (회원)

  • MEM_ID (Key) — VARCHAR2(20) — 기본 키 — NOT NULL
  • MEM_PASS (Field) — VARCHAR2(80)
  • MEM_PASSLENG (Field8) — VARCHAR2(2)
  • MEM_TEMP_PASS (Field5) — VARCHAR2(80)
  • MEM_NAME (Field2) — VARCHAR2(20)
  • MEM_EMAIL (Field3) — VARCHAR2(100)
  • MEM_TEL (Field4) — VARCHAR2(14)
  • MEM_TYPE (Field7) — VARCHAR2(1)
  • MEM_REGDATE (Field9) — DATE
  • MEM_EXITDATE (Field10) — DATE
  • PREFECTURE_CODE (Field6) — VARCHAR2(10 BYTE)
  • MUNICIPALITY_CODE (Field11) — VARCHAR2(20 BYTE)

MUNICIPALITY (시구정촌)

  • MUNICIPALITY_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • COUNTRY_CODE (Field2) — VARCHAR2(2 BYTE)
  • PREFECTURE_CODE (Field3) — VARCHAR2(10 BYTE)
  • MUNICIPALITY_CODE (Field4) — VARCHAR2(20 BYTE)
  • MUNICIPALITY_NAME (Field) — VARCHAR2(100 BYTE)
  • OFFICIAL_NAME (Field5) — VARCHAR2(200 BYTE)
  • CREATED_AT (Field6) — TIMESTAMP(6)
  • UPDATED_AT (Field7) — TIMESTAMP(6)

NOTICE (공지사항)

  • NOTICE_NO (Key) — VARCHAR2(10) — 기본 키 — NOT NULL
  • NOTICE_TITLE (Field2) — VARCHAR2(100)
  • NOTICE_CONTENT (Field3) — VARCHAR2(2000)
  • NOTICE_ATTACH (Field4) — VARCHAR2(50)
  • NOTICE_TYPE (Field) — VARCHAR2(1)
  • NOTICE_REGDATE (Field6) — DATE
  • MEM_ID (Key2) — VARCHAR2(20) — 외래 키 → MEMBER.MEM_ID — NOT NULL

WASTE_CATEGORY (쓰레기 분류)

  • CATEGORY_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • CATEGORY_CODE (Field) — VARCHAR2(50 BYTE)
  • CATEGORY_NAME (Field2) — VARCHAR2(100 BYTE)
  • DESCRIPTION (Field3) — VARCHAR2(1000 BYTE)
  • CREATED_AT (Field4) — TIMESTAMP(6)
  • UPDATED_AT (Field5) — TIMESTAMP(6)

WASTE_ITEM (쓰레기 품목)

  • ITEM_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • ITEM_CODE (Field) — VARCHAR2(50 BYTE)
  • ITEM_NAME (Field2) — VARCHAR2(200 BYTE)
  • DESCRIPTION (Field3) — VARCHAR2(1000 BYTE)
  • CREATED_AT (Field4) — TIMESTAMP(6)
  • UPDATED_AT (Field5) — TIMESTAMP(6)