경조사 관리자

테이블 (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