Sopkathon-DO-SOPT
Tables (3)
applies (Apply)
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- program_id — bigint — Foreign key → programs.id — NOT NULL
- status — varchar(10)
- register_at — LocalDateTime
- done_at — LocalDateTime
programs (Program)
- id — bigint — Primary key — NOT NULL
- title — varchar(255)
- category — varchar(255)
- organization_name — varchar(255)
- region — varchar(255)
- content — text
- dtype — varchar(255)
- volunteer_hours — bigint
- salary — bigint
- register_at — LocalDateTime
- done_at — LocalDateTime
users (User)
- id — bigint — Primary key — NOT NULL
- name — varchar(255)
- gender — varchar(10)
- thumbnail — varchar(255)
- age — bigint