최종

테이블 (13)

Group

  • group_id — INT_UNSIGNED — 기본 키 — NOT NULL
  • group_name — VARCHAR(20) — NOT NULL
  • group_introduce — VARCHAR(1000) — NOT NULL
  • group_location — VARCHAR(50) — NOT NULL
  • group_zone — VARCHAR(10) — NOT NULL
  • group_logo_path — VARCHAR(50) — NOT NULL
  • group_photo_path — VARCHAR(50) — NOT NULL

Group_User

  • group_user_id — INT_UNSIGNED — 기본 키 — NOT NULL
  • user_id — INT — NOT NULL
  • group_id — INT_UNSIGNED — NOT NULL
  • group_user_status — TINYINT(2) — NOT NULL
  • group_user_date — DATETIME — NOT NULL

Notification

  • notification_id — INT — 기본 키 — NOT NULL
  • notification_content — VARCHAR(200) — NOT NULL
  • notification_status — TINYINT(2) — NOT NULL
  • notification_created_at — DATETIME — NOT NULL
  • user_id — INT — NOT NULL
  • pre_id — INT — NOT NULL

Notify

  • notify_id — INT_UNSIGNED — 기본 키 — NOT NULL
  • notify_name — INT — NOT NULL
  • notify_email — VARCHAR(50)
  • notify_phone — VARCHAR(20) — NOT NULL
  • notify_location — VARCHAR(50) — NOT NULL
  • notify_x — DOUBLE — NOT NULL
  • notify_y — DOUBLE — NOT NULL
  • notify_detail_location — VARCHAR(200)
  • notify_date — DATE — NOT NULL
  • notify_time — TIME — NOT NULL
  • notify_access — INT — NOT NULL
  • notify_busy — INT — NOT NULL
  • notify_content — VARCHAR(2000)

Notify_Photo

  • nphoto_id — INT — 기본 키 — NOT NULL
  • nphoto_path — VARCHAR(50) — NOT NULL
  • nphoto_content — VARCHAR(2000)
  • notify_id — INT_UNSIGNED — NOT NULL

Notify_Trash

  • ntrash_id — INT — 기본 키 — NOT NULL
  • ntrash_type — VARCHAR(10) — NOT NULL
  • ntrash_volume — INT — NOT NULL
  • notify_id — INT_UNSIGNED — NOT NULL

Pin

  • pin_id — INT_UNSIGNED — 기본 키 — NOT NULL
  • pin_location — VARCHAR(50) — NOT NULL
  • pin_x — DOUBLE — NOT NULL
  • pin_y — DOUBLE — NOT NULL
  • pin_time — DATETIME — NOT NULL

Pre_Register

  • pre_id — INT — 기본 키 — NOT NULL
  • pre_title — VARCHAR(20) — NOT NULL
  • pre_content — VARCHAR(1000) — NOT NULL
  • pre_other — TINYINT(2) — NOT NULL
  • pin_id — INT_UNSIGNED — NOT NULL
  • group_id — INT_UNSIGNED — NOT NULL

Pre_Register_User

  • pre_user_id — INT_UNSIGNED — 기본 키 — NOT NULL
  • pre_id — INT — NOT NULL
  • group_user_id — INT_UNSIGNED — NOT NULL

User

  • user_id — INT — 기본 키 — NOT NULL
  • user_name — VARCHAR(10) — NOT NULL
  • user_email — VARCHAR(50) — NOT NULL
  • user_password — VARCHAR(20) — NOT NULL
  • user_phone — VARCHAR(20) — NOT NULL
  • user_role — ENUM('user', 'leader', 'admin') — NOT NULL
  • user_gender — TINYINT(2) — NOT NULL
  • user_created_at — DATETIME — NOT NULL
  • user_updated_at — DATETIME — NOT NULL

Volunteer

  • volunteer_id — INT_UNSIGNED — 기본 키 — NOT NULL
  • volunteer_people — INT — NOT NULL
  • volunteer_title — VARCHAR(20) — NOT NULL
  • volunteer_date — DATE — NOT NULL
  • volunteer_time — TIME — NOT NULL
  • volunteer_detail_location — VARCHAR(50)
  • volunteer_content — VARCHAR(2000) — NOT NULL
  • volunteer_degree — INT — NOT NULL
  • group_id — INT_UNSIGNED — NOT NULL
  • pin_id — INT_UNSIGNED — NOT NULL

Volunteer_Photo

  • vphoto_id — INT — 기본 키 — NOT NULL
  • vphoto_path — VARCHAR(50) — NOT NULL
  • volunteer_id — INT_UNSIGNED — NOT NULL

Volunteer_Trash

  • vtrash_id — INT — 기본 키 — NOT NULL
  • vtrash_type — VARCHAR(10) — NOT NULL
  • vtrash_weight — INT — NOT NULL
  • volunteer_id — INT_UNSIGNED — NOT NULL
  • group_id — INT_UNSIGNED — NOT NULL