likelion

Tables (18)

answer

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • text — varchar(500) — NOT NULL
  • application_id — bigint
  • question_id — bigint

applications

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • department_type — enum
  • grade — int — NOT NULL
  • in_school — bit — NOT NULL
  • is_personal_info_consent — bit — NOT NULL
  • major — varchar(100) — NOT NULL
  • part — enum — NOT NULL
  • portfolio_name — varchar(255)
  • status — enum — NOT NULL
  • student_id — varchar(255) — NOT NULL
  • submitted_at — datetime(6)
  • recruitment_id — bigint
  • user_id — bigint

blog_image

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • url — varchar(255) — NOT NULL
  • post_id — bigint — NOT NULL

blog_post

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • category — enum — NOT NULL
  • content — longtext — NOT NULL
  • status — enum — NOT NULL
  • thumbnail_url — varchar(255)
  • title — varchar(100) — NOT NULL
  • author_id — bigint — NOT NULL

blog_post_tag

  • post_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Primary key — NOT NULL

certification_tokens

  • id — bigint
  • code — varchar(255)
  • email — varchar(255)
  • expired_at — datetime(6)

lion_info

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • department_type — enum
  • generation — int — NOT NULL
  • part — enum — NOT NULL
  • role — enum — NOT NULL
  • user_id — bigint

notice

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — text — NOT NULL
  • pinned — bit — NOT NULL
  • summary — text
  • title — varchar(100) — NOT NULL

portfolio_links

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • name — enum — NOT NULL
  • url — varchar(200) — NOT NULL
  • user_id — bigint

project_keywords

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • name — varchar(255)
  • project_id — bigint

project_participation

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • like_lion_info_id — bigint
  • project_id — bigint

project_retrospection

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — text — NOT NULL
  • project_id — bigint
  • writer_id — bigint

projects

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • appstore_url — varchar(255)
  • category — enum — NOT NULL
  • description — varchar(255) — NOT NULL
  • generation — int — NOT NULL
  • images — text — NOT NULL
  • intro — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • playstore_url — varchar(255)
  • tags — varchar(255)
  • website_url — varchar(255)

question

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • button_list — varchar(255)
  • department_type — enum
  • order_num — int — NOT NULL
  • part — enum
  • question_target — enum — NOT NULL
  • question_type — enum — NOT NULL
  • text — varchar(255) — NOT NULL
  • recruitment_id — bigint

recruitment

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • close_date — datetime(6) — NOT NULL
  • generation — int — NOT NULL
  • open_date — datetime(6) — NOT NULL
  • recruitment_type — enum — NOT NULL
  • start_notified — bit — NOT NULL

recruitment_subscription

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • email — varchar(255) — NOT NULL
  • subscription_type — enum — NOT NULL

refresh_token

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • email — varchar(50) — NOT NULL
  • payload — varchar(255) — NOT NULL

users

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • description — longtext
  • email — varchar(255)
  • intro — varchar(255)
  • major — varchar(100)
  • password — varchar(255) — NOT NULL
  • phone_number — varchar(255)
  • profile_image_url — longtext
  • saying — varchar(200)
  • stacks — varchar(255)
  • username — varchar(255)