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