dangdang
Tables (9)
comment (Untitled)
- id — varchar(255) — Primary key — NOT NULL
- content — longtext
- referenceId — bigint
- comment_type — varchar(20)
- depth — int
- created_at — datetime(6)
- updated_at — datetime(6)
- writer_nickname — varchar(30
- writer_email — varchar(50
- visable — bit
- chlidren — List<comment>
- writer_id — bigint — Foreign key → user.id
interview_question
- id — bigint — Primary key
- answer — longtext
- field — varchar(25)
- question — varchar(300)
- visable — bit
- writer — bigint — Foreign key → user.id
joins
- id — bigint — Primary key
- study_id — bigint — Foreign key → study.id
- user_id — bigint — Foreign key → user.id
- waiting — bit
post
- id — bigint — Primary key
- content — longtext
- created_at — datetime(6)
- title — varchar(300)
- updated_at — datetime(6)
- study_id — bigint
- writer — bigint — Foreign key → user.id
resume
- id — bigint — Primary key
- writer — bigint — Foreign key → user.id
resume_question
- id — bigint — Primary key
- answer — longtext
- question — varchar(300)
- resume_id — bigint — Foreign key → resume.id
study
- id — bigint — Primary key
- created_at — datetime(6)
- description — longtext
- goal — varchar(30)
- last_access_time — datetime(6)
- name — varchar(30)
- number — int
- open_kakao — varchar(255)
- total_time — int
- host_id — bigint — Foreign key → user.id
study_hash_tag
- id — bigint — Primary key
- hash_tag — varchar(30)
- study_id — bigint — Foreign key → study.id
user
- id — bigint — Primary key
- email — varchar(50) — NOT NULL
- image_url — varchar(255)
- nickname — varchar(30)
- password — varchar(255)
- provider — varchar(255)
- provider_id — varchar(255)
- role — varchar(255)