가져오기

테이블 (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