컨설팅
테이블 (7)
comments
- id — SERIAL
- post_id — INTEGER
- user_id — INTEGER
- content — TEXT — NOT NULL
- parent_comment_id — INTEGER
- created_at — TIMESTAMP
community_posts
- id — SERIAL
- user_id — INTEGER
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
likes
- id — SERIAL
- post_id — INTEGER
- user_id — INTEGER
- created_at — TIMESTAMP
reservations
- id — SERIAL
- user_id — INTEGER
- schedule_id — INTEGER
- status — VARCHAR(20)
- payment_link — TEXT
- created_at — TIMESTAMP
schedule_edit_invites
- id — SERIAL
- schedule_id — INTEGER
- inviter_id — INTEGER
- invitee_id — INTEGER
- created_at — TIMESTAMP
schedules
- id — SERIAL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- creator_id — INTEGER
- is_recommended — BOOLEAN
- is_direct_input — BOOLEAN
- created_at — TIMESTAMP
users
- id — SERIAL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- sns_link — TEXT
- profile_image — TEXT
- role — VARCHAR(20)
- created_at — TIMESTAMP