팀프로젝트 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)