경조사 관리자
테이블 (3)
Contact (contact)
- ContactID (contact_id) — INT — 기본 키 — NOT NULL
- NAME (name) — VARCHAR
- GROUP (group) — VARCHAR
- NUMBER (number) — VARCHAR
- MEMO (memo) — VARCHAR
- IMG (img) — VARCHAR
History (내역)
- HistoryId (history_id) — INT — 기본 키 — NOT NULL
- ContactID (contact_id) — INT — 외래 키 → Contact.ContactID — NOT NULL
- Event (event2) — VARCHAR — 외래 키 → MyEvent.Event — NOT NULL
- NAME (name) — VARCHAR
- GROUP (group) — VARCHAR
- EVENT (event) — VARCHAR
- EVNETTYPE (eventType) — VARCHAR
- DATE (date) — VARCHAR
- TYPE (type) — VARCHAR
- AMOUNT (amount) — INT
- ROUTE (route) — VARCHAR
- PLACE (place) — VARCHAR
- MEMO (memo) — VARCHAR
MyEvent (myevent)
- Event (event) — VARCHAR — 기본 키 — NOT NULL
- EVNETTYPE (eventType) — VARCHAR
- DATE (date) — VARCHAR
- PLACE (place) — VARCHAR
- MEMO (memo) — VARCHAR