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