Database_proj

Tables (7)

Claim (claim)

  • Claim ID (claim_id) — INT(11) — Primary key — NOT NULL
  • Date (date) — DATE
  • Pay (pay) — INT(11)
  • Reason (reason) — VARCHAR(300)
  • User ID (user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Policy ID (policy_id) — INT(11) — Foreign key → Policy.Policy ID — NOT NULL
  • Event ID (event_id) — INT(11) — Foreign key → Event.Event ID — NOT NULL
  • Payment ID (payment_id) — INT(11) — Foreign key → Payment.Payment ID — NOT NULL

Clan (clan)

  • Clan ID (clan_id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(50)
  • Location (location) — VARCHAR(50)
  • Fame (fame) — VARCHAR(100)
  • User ID (user_id) — INT(11) — Foreign key → User.User ID — NOT NULL

Event (event)

  • Event ID (event_id) — INT(11) — Primary key — NOT NULL
  • Description (desc) — VARCHAR(500)
  • Date (date) — DATE
  • Related Clan (clan) — VARCHAR(30)
  • Injury Info (injury_info) — VARCHAR(100)
  • User ID (user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Clan ID (clan_id) — INT(11) — Foreign key → Clan.Clan ID — NOT NULL

Payment (payment)

  • Payment ID (payment_id) — INT(11) — Primary key — NOT NULL
  • Date (date) — DATE
  • Amount (amount) — INT(11)
  • State (state) — BOOLEAN

Policy (policy)

  • Policy ID (policy_id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(50)
  • Detail (detail) — VARCHAR(200)
  • Premium (premium) — INT(11)
  • Expiration (expiration) — DATE

User (user)

  • User ID (user_id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(50)
  • Age (age) — INT(11)
  • Level (level) — VARCHAR(10)
  • Gender (gender) — VARCHAR(10)
  • Clan (clan) — VARCHAR(30)

User_Policy_joinTable (user_policy)

  • User ID (user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Policy ID (policy_id) — INT(11) — Foreign key → Policy.Policy ID — NOT NULL