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