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)