SKKU-DM
Tables (11)
Comment
- id — SERIAL
- user_id — INTEGER — NOT NULL
- post_id — INTEGER — NOT NULL
- parent_id — INTEGER
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Major
- id — SERIAL
- name — VARCHAR(255) — NOT NULL
- meta — JSONB — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Post
- id — SERIAL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- userId — INTEGER — NOT NULL
- likes — INTEGER
- tags — VARCHAR
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Profile
- id — SERIAL
- image_url — VARCHAR(255) — NOT NULL
- intro — TEXT — NOT NULL
- interests — VARCHAR — NOT NULL
- public — BOOLEAN — NOT NULL
- user_id — INTEGER — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Square
- id — SERIAL
- name — VARCHAR(255) — NOT NULL
- leader_id — INTEGER — NOT NULL
- major_id — INTEGER
- max — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
SquarePostComment
- id — SERIAL
- userId — INTEGER — NOT NULL
- squarePostId — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
User
- id — SERIAL
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- role — Role
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- admit_year — INTEGER
- real — BOOLEAN
mock_apply
- id — SERIAL
- user_id — INTEGER — NOT NULL
- major_id — INTEGER — NOT NULL
- score — FLOAT — NOT NULL
square_post
- id — SERIAL
- user_id — INTEGER — NOT NULL
- square_id — INTEGER — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_major
- user_id — INTEGER — Primary key — NOT NULL
- major_id — INTEGER — Primary key — NOT NULL
- origin — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_square
- user_id — INTEGER — Primary key — NOT NULL
- square_id — INTEGER — Primary key — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP