AL
Tables (10)
Message
- id — bigint — Primary key — NOT NULL
- channelId — varchar(255)
- createdAt — datetime(6)
- data — varchar(255)
- sender — varchar(255)
- type — varchar(255)
Refresh
- id — bigint — Primary key — NOT NULL
- expiration — varchar(255)
- refresh — varchar(255)
- username — varchar(255)
group_problems
- id — bigint — Primary key — NOT NULL
- group_id (id2) — bigint — Foreign key → study_groups.id — NOT NULL
- problem_id (id3) — bigint — Foreign key → problems.id — NOT NULL
- createdAt — datetime(6)
- deadline — datetime(6)
- deductionAmount — decimal(38,2)
- deduct — enum('FALSE','TRUE')
payments
- id — bigint — Primary key — NOT NULL
- amount — decimal(38,2)
- createdAt — datetime(6)
- orderId — varchar(255) — NOT NULL
- paymentKey — varchar(255)
- refundedAt — datetime(6)
- requestedAt — varchar(255)
- totalAmount — varchar(255)
problems
- id — bigint — Primary key — NOT NULL
- createdAt — datetime(6)
- description — varchar(1000)
- difficultyLevel — varchar(255)
- title — varchar(255)
- exampleInput — varchar(255)
- exampleOutput — varchar(255)
- problemType — enum('BACKTRACKING','BRUTE_FORCE','DIVIDE_AND_CONQUER','DYNAMIC_PROGRAMMING','GRAPH','GREEDY','IMPLEMENTATION')
- inputDescription — varchar(1000)
- outputDescription — varchar(1000)
study_groups
- id — bigint — Primary key — NOT NULL
- deposit_amount — decimal(10,2)
- createdAt — datetime(6)
- deadline — datetime(6)
- study_end_date — datetime(6) — NOT NULL
- leader — varchar(255) — NOT NULL
- name — varchar(255)
- password — varchar(255) — NOT NULL
submissions
- id — bigint — Primary key — NOT NULL
- user_id (id2) — bigint — Foreign key → users.id — NOT NULL
- group_problem_id (id3) — bigint — Foreign key → group_problems.id — NOT NULL
- submissionTime — datetime(6)
- code — varchar(255)
- language — varchar(255)
- status — varchar(255)
test_cases
- id — bigint — Primary key — NOT NULL
- problem_id (id2) — bigint — Foreign key → problems.id — NOT NULL
- expectedOutput — varchar(255)
- input — text
user_groups
- id — bigint — Primary key — NOT NULL
- user_id (id2) — bigint — Foreign key → users.id — NOT NULL
- group_id (id3) — bigint — Foreign key → study_groups.id — NOT NULL
- user_deposit_amount — decimal(10,2)
- charged — bit(1) — NOT NULL
- payment_key — varchar(255)
- refunded — bit(1) — NOT NULL
users
- id — bigint — Primary key — NOT NULL
- password — varchar(255) — NOT NULL
- username — varchar(255) — NOT NULL
- role — enum('ROLE_ADMIN','ROLE_USER') — NOT NULL
- customerId — varchar(255) — NOT NULL