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