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