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)