PooddingERD
Tables (11)
calendar
- calendar_id — VARCHAR(255) — Primary key — NOT NULL
- creator_id — VARCHAR(255) — Foreign key → member.admin_id — NOT NULL
- calendar_name — VARCHAR(255) — NOT NULL
- calendar_description — TEXT
- is_public — BOOLEAN — NOT NULL
- calendar_color — VARCHAR(20)
- user_id — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- invitation_code — VARCHAR(255)
comment
- comment_id — VARCHAR(255) — Primary key — NOT NULL
- event_id — VARCHAR(255) — Foreign key → event.event_id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- admin_id — VARCHAR(255) — Foreign key → member.admin_id — NOT NULL
comment_like
- like_id — VARCHAR(255) — Primary key — NOT NULL
- comment_id — VARCHAR(255) — Foreign key → comment.comment_id — NOT NULL
- user_id — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- created_at — DATETIME — NOT NULL
contact
- contact_id — VARCHAR(255) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(20)
- email — VARCHAR(255)
- admin_id — VARCHAR(255) — Foreign key → member.admin_id — NOT NULL
event
- event_id — VARCHAR(255) — Primary key — NOT NULL
- calendar_id — VARCHAR(255) — Foreign key → calendar.calendar_id — NOT NULL
- location_id — VARCHAR(255) — Foreign key → location.location_id
- event_title — VARCHAR(255) — NOT NULL
- event_description — TEXT
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- admin_id — VARCHAR(255) — Foreign key → member.admin_id — NOT NULL
favorite_event
- favorite_event_id — VARCHAR(255) — Primary key — NOT NULL
- user_id — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- event_id — VARCHAR(255) — Foreign key → event.event_id — NOT NULL
- d_day — DATE
- easy_insidebar — BOOLEAN
location
- location_id — VARCHAR(255) — Primary key — NOT NULL
- address_line1 — VARCHAR(255) — NOT NULL
- city — VARCHAR(255) — NOT NULL
- country — VARCHAR(255) — NOT NULL
- latitude — DECIMAL(10,8)
- longitude — DECIMAL(11,8)
member (admin)
- admin_id — VARCHAR(255) — Primary key — NOT NULL
- user_id — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- calendar_id — VARCHAR(255) — Foreign key → calendar.calendar_id — NOT NULL
notification
- notification_id — VARCHAR(255) — Primary key — NOT NULL
- user_id — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- event_id — VARCHAR(255) — Foreign key → event.event_id — NOT NULL
- notification_time — DATETIME — NOT NULL
- is_read — BOOLEAN — NOT NULL
subscription
- subscription_id — VARCHAR(255) — Primary key — NOT NULL
- user_id — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
- calendar_id — VARCHAR(255) — Foreign key → calendar.calendar_id — NOT NULL
user
- user_id — VARCHAR(255) — Primary key — NOT NULL
- user_birth — DATE
- user_email — VARCHAR(255) — NOT NULL
- user_password — CHAR(60) — NOT NULL
- user_name — VARCHAR(255) — NOT NULL
- user_profile_image — VARCHAR(255)
- user_nickname — VARCHAR(255)