gdsc-uos-brading
Tables (9)
Untitled (application)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (team_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — bigint(20) — Foreign key → user.Key — NOT NULL
- Field (season) — varchar(20) — NOT NULL
- Field (status) — varchar(20)
- Field (is_core_member) — boolean — NOT NULL
Untitled (team)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (name) — varchar(20) — NOT NULL
Untitled (application_question)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (team_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Key (application_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (question) — varchar(255)
- Field (answer) — varchar(255)
- Field (required) — boolean — NOT NULL
- Field (max_length) — bigint(20) — NOT NULL
Untitled (application_critic)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (application_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Key (critic_user_id) — bigint(20) — Foreign key → user.Key — NOT NULL
- Field (status) — enum("document", "interview")
- Field (result) — varchar(20)
- Field (comment) — varchar(255)
Untitled (introduction)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (team_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (about) — varchar(255)
- Field (activity) — varchar(255)
- Field (target) — varchar(255)
base_entity
- Field (created_at) — datetime — NOT NULL
- Field2 (created_by) — varchar(255)
- Field (date_modified) — datetime — NOT NULL
- Field2 (modified_ip) — varchar(255)
base_time_entity
- createdAt — datetime — NOT NULL
- createdBy — varchar(255)
dashboard
- id — bigint(20) — NOT NULL
- team_nm — varcher(20)
- team_cnt — int
- team_apply_cnt — int
- team_marked_cnt — int
user
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (team_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (username) — varchar(15) — NOT NULL
- Field (email) — varchar(255)
- Field (role) — varchar(20) — NOT NULL
- Field (date_created) — datetime
- (create_ip) — varchar(255)