MeeVote
Tables (13)
Copy Of Untitled (place_voting_items)
- Key (place_voting_items_id) — number — Primary key — NOT NULL
- Key (schedule_id) — number — Foreign key → Untitled.Key — NOT NULL
- Field (place_name) — varchar2(255) — NOT NULL
- Field (place_latitude) — number — NOT NULL
- Field (place_longitude) — number — NOT NULL
Copy Of Untitled2 (place_voted)
- Key (place_voted_id) — number — Primary key — NOT NULL
- Key (email) — varchar2(255) — Foreign key → Untitled.Key — NOT NULL
- Key (schedule_id) — number — Foreign key → Untitled.Key — NOT NULL
- Key (place_to_vote_id) — number — Foreign key → Copy Of Untitled.Key — NOT NULL
Copy Of Untitled3 (notify_category)
- Key (notify_category_id) — number — Primary key — NOT NULL
- Field (notify_category_name) — varchar2(50) — NOT NULL
Member (member)
- Key (email) — varchar2(255) — Primary key — NOT NULL
- Field (password) — varchar2(50) — NOT NULL
- Field (name) — varchar2(50) — NOT NULL
- Field (phone_number) — varchar2(50) — NOT NULL
- Field (address) — varchar2(50) — NOT NULL
- Field (img_src) — varchar2(255) — NOT NULL
- Field (is_banned) — number(1) — NOT NULL
Untitled (member_ban)
- Key (member_ban_id) — number — Primary key — NOT NULL
- Key (member_email) — varchar2(255) — Foreign key → Member.Key — NOT NULL
- Key (admin_email) — varchar2(50) — Foreign key → Untitled.Key — NOT NULL
- Field (start_date) — date — NOT NULL
- Field (end_date) — date — NOT NULL
Untitled (schedule_category)
- Key (schedule_category_id) — number — Primary key — NOT NULL
- Field (schedule_category_name) — varchar2(50) — NOT NULL
- Field (schedule_color) — varchar2(20) — NOT NULL
Untitled (date_voted)
- Key (date_voted_id) — number — Primary key — NOT NULL
- Key (email) — varchar2(255) — Foreign key → Untitled.Key — NOT NULL
- Key (schedule_id) — number — Foreign key → Untitled.Key — NOT NULL
- Field (start_date) — date — NOT NULL
- Field (end_date) — date — NOT NULL
Untitled (member_schedule)
- Key (email) — varchar2(255) — Foreign key → Member.Key — NOT NULL
- Key (schedule_id) — number — Foreign key → Untitled.Key — NOT NULL
- Field (is_owner) — number(1) — NOT NULL
- Field (attedance) — number(1) — NOT NULL
Untitled (schedule)
- Key (schedule_id) — number — Primary key — NOT NULL
- Key (schedule_category_id) — number — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar2(50) — NOT NULL
- Field (description) — varchar2(50)
- Field (is_group) — number(1) — NOT NULL
- Field (duration) — number — NOT NULL
- Field (start_date) — date
- Field (end_date) — date
- Field (place_name) — varchar2(255)
- Field (place_latitude) — number
- Field (place_longitude) — number
Untitled (date_voting_items)
- Key (date_voting_items_id) — number — Primary key — NOT NULL
- Key (schedule_id) — number — Foreign key → Untitled.Key — NOT NULL
- Field (start_date) — date — NOT NULL
- Field (end_date) — date — NOT NULL
Untitled (administer)
- Key (email) — varchar2(255) — Primary key — NOT NULL
- Field (password) — varchar2(50) — NOT NULL
- Field (name) — varchar2(50) — NOT NULL
Untitled (notify)
- Key (notify_id) — number — Primary key — NOT NULL
- Key (email) — varchar2(255) — Foreign key → Member.Key — NOT NULL
- Key (schedule_id) — number — Foreign key → Untitled.Key — NOT NULL
- Key (notify_category_id) — number — Foreign key → Copy Of Untitled3.Key — NOT NULL
- Field (is_read) — number(1) — NOT NULL
Untitled (schedule_vote)
- Key (schedule_id) — number — Foreign key → Untitled.Key — NOT NULL
- Field (date_vote_deadline) — date — NOT NULL
- Field (place_vote_deadline) — date