가져오기
테이블 (11)
categories
- id — INTEGER — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
chat_room_members
- id — INTEGER — 기본 키 — NOT NULL
- chatroom_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- last_read_message_id — INTEGER
- joined_at — TIMESTAMP
chat_rooms
- id — INTEGER — 기본 키 — NOT NULL
- group_id — INTEGER — NOT NULL
- created_by — INTEGER — NOT NULL
- created_at — TIMESTAMP
events
- id — INTEGER — 기본 키 — NOT NULL
- group_id — INTEGER — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- event_date — DATE — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
groups
- id — INTEGER — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- profile_image — VARCHAR(255)
- description — TEXT
- category_id — INTEGER — NOT NULL
- created_by — INTEGER — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
memberships
- id — INTEGER — 기본 키 — NOT NULL
- user_id — INTEGER — NOT NULL
- group_id — INTEGER — NOT NULL
- role — VARCHAR(50) — NOT NULL
- joined_at — TIMESTAMP
message_read_status
- id — INTEGER — 기본 키 — NOT NULL
- message_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- read_at — TIMESTAMP
messages
- id — INTEGER — 기본 키 — NOT NULL
- chatroom_id — INTEGER — NOT NULL
- sender_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- unread_count — INTEGER
- sent_at — TIMESTAMP
photos
- id — INTEGER — 기본 키 — NOT NULL
- group_id — INTEGER — NOT NULL
- uploader_id — INTEGER — NOT NULL
- url — VARCHAR(255) — NOT NULL
- uploaded_at — TIMESTAMP
posts
- id — INTEGER — 기본 키 — NOT NULL
- group_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- id — INTEGER — 기본 키 — NOT NULL
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP