muldum

Tables (18)

Award

  • id — int
  • team_id — int — Foreign key → Team.id
  • year — int — NOT NULL
  • rank — int — NOT NULL

Banner

  • id — int
  • team_id — int — Foreign key → Team.id
  • file_id — int — Foreign key → S3.id
  • updated_at — datetime

Calendar

  • id — int
  • team_id — int — Foreign key → Team.id
  • start_at — datetime
  • end_at — datetime
  • updated_at — datetime

Comment

  • id — int
  • type — enum(notice,gallery)
  • commented_at — int — Foreign key → Notice.id — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • content — text
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

Document

  • id — int
  • team_id — int — Foreign key → Team.id
  • title — varchar2(50) — NOT NULL
  • filebook_id — int — Foreign key → FileBook.filebook_id
  • created_at — datetime
  • updated_at — datetime

FileBook

  • id — int
  • filebook_id — int — Foreign key → Notice.filebook_id
  • file_id — int — Foreign key → S3.id

Gallery

  • id — int
  • type — enum(design,major,network,free)
  • team_id — int — Foreign key → Team.id — NOT NULL
  • filebook_id — int — NOT NULL
  • title — varchar2(20)

ItemBudget

  • id — int
  • team_id — int — Foreign key → Team.id — NOT NULL
  • total_budget — int — NOT NULL
  • used_budget — int
  • updated_at — datetime

ItemRequest

  • id — int
  • team_id — int — Foreign key → Team.id — NOT NULL
  • product_name — varchar(100) — NOT NULL
  • quantity — int
  • price — int
  • product_link — text
  • item_source — varchar2(20) — Foreign key → ItemSource.id
  • status — enum(PENDING,APPROVED,REJECTED)
  • reason — text

ItemSource

  • id — varchar2(20)
  • label — varchar2(20) — NOT NULL
  • description — text

Member

  • id — int
  • user_id — int — Foreign key → User.id — NOT NULL
  • team_id — int — Foreign key → Team.id — NOT NULL

Notice

  • id — int
  • user_id — int — Foreign key → User.id — NOT NULL
  • team_id — int — Foreign key → Team.id
  • title — varchar2(20) — NOT NULL
  • filebook_id — int
  • is_alerted — boolean

S3

  • id — int
  • file_url — text — NOT NULL
  • file_name — varchar2(100)
  • file_type — varchar2(30)
  • file_extension — varchar2(10)
  • user_id — int — Foreign key → User.id
  • updated_at — datetime — NOT NULL

Team

  • id — int
  • name — varchar2(40) — NOT NULL
  • readme — text

TeamSpace

  • id — int
  • team_id — int — Foreign key → Team.id
  • filebook_id — int — Foreign key → FileBook.filebook_id

Test

  • id — int
  • team_id — int — Foreign key → Team.id — NOT NULL
  • title — varchar2(40) — NOT NULL
  • object1 — varchar2(40) — NOT NULL
  • object2 — varchar2(40) — NOT NULL
  • stacks — text — NOT NULL
  • teacher_feedback — text — NOT NULL
  • mento_feedback — text — NOT NULL
  • created_at — datetime — NOT NULL

Token

  • id — int
  • user_id — int — Foreign key → User.id — NOT NULL
  • refresh_token — text — NOT NULL
  • device_info — varchar(255)
  • ip_address — varchar(50)
  • is_revoked — boolean
  • created_at — datetime
  • expires_at — datetime — NOT NULL

User

  • id — int
  • bsm_id — int — NOT NULL
  • name — varchar2(4) — NOT NULL
  • enrolled_at — int — NOT NULL
  • email — text — NOT NULL
  • class_no — int — NOT NULL
  • grade — int — NOT NULL
  • user_role — enum(student,teacher,mento) — NOT NULL