게시판

테이블 (10)

category (Untitled5)

  • category_id (Key) — uuid — 기본 키 — NOT NULL
  • category_name (Field) — varchar(40)

comment (Untitled3)

  • comment_id (Key) — uuid — 기본 키 — NOT NULL
  • created_at (Field4) — timestamp with time zone
  • paragraph (Field5) — varchar(1000)
  • parent_comment_id (Field8) — uuid
  • updated_at (Field9) — timestamp with time zone
  • article_id (Key4) — uuid — 외래 키 → meeting.meeting_id — NOT NULL

meeting (Untitled2)

  • meeting_id (Key) — uuid — 기본 키 — NOT NULL
  • title (Field) — varchar(40)
  • paragrph (Field2) — varchar(1000)
  • created_at (Field3) — timestamp with time zone
  • views (Field6) — integer
  • updated_at (Field7) — timestamp with time zone
  • category_id (Key4) — uuid — 외래 키 → category.category_id — NOT NULL
  • user_id (Key3) — uuid — 외래 키 → user.user_id — NOT NULL
  • category (Field4) — varchar
  • meeting_type (Field5) — varchar
  • participant (Field8) — integer
  • date (Field9) — varchar
  • fee (Field10) — integer

photo (Untitled4)

  • file_id (Key) — uuid — 기본 키 — NOT NULL
  • records_id (Key2) — uuid — 외래 키 → records.records_id — NOT NULL
  • user_meeting_id (Key22) — uuid — 외래 키 → records.user_meeting_id — NOT NULL
  • meeting_id (Key222) — uuid — 외래 키 → records.meeting_id — NOT NULL
  • user_id (Key32) — uuid — 외래 키 → records.user_id — NOT NULL
  • file_path (Field) — varchar(100)
  • file_origin_name (Field2) — varchar(100)
  • file_save_name (Field3) — varchar(100)
  • meeting_id (Key3) — uuid — 외래 키 → meeting.meeting_id — NOT NULL

records (CopyOfUntitled2)

  • records_id (Key) — uuid — 기본 키 — NOT NULL
  • user_meeting_id (Key2) — uuid — 외래 키 → user_meeting.user_meeting_id — NOT NULL
  • meeting_id (Key22) — uuid — 외래 키 → user_meeting.meeting_id — NOT NULL
  • user_id (Key3) — uuid — 외래 키 → user_meeting.user_id — NOT NULL
  • title (Field) — varchar(40)
  • paragrph (Field2) — varchar(1000)
  • created_at (Field3) — timestamp with time zone
  • updated_at (Field7) — timestamp with time zone
  • date (Field9) — varchar
  • attendance_check (Field4) — enum

user (Untitled)

  • user_id (Key) — uuid — 기본 키 — NOT NULL
  • username (Field) — varchar
  • password (Field2) — bytea
  • mail (Field3) — varchar
  • department (Field4) — varchar
  • student_id (Field5) — varchar
  • attendance_score (Field6) — ingeter

user_comment (Untitled8)

  • user_comment_id (Key) — uuid — 기본 키 — NOT NULL
  • comment_id (Key3) — uuid — 외래 키 → comment.comment_id — NOT NULL
  • user_id (Key2) — uuid — 외래 키 → user.user_id — NOT NULL

user_like (Untitled6)

  • user_like_id (]) — uuid — 기본 키 — NOT NULL
  • user_id (Key) — uuid — 외래 키 → user.user_id — NOT NULL
  • article_id (Key2) — uuid — 외래 키 → meeting.meeting_id — NOT NULL

user_meeting (Untitled10)

  • user_meeting_id (Key) — uuid — 기본 키 — NOT NULL
  • meeting_id (Key2) — uuid — 외래 키 → meeting.meeting_id — NOT NULL
  • user_id (Key3) — uuid — 외래 키 → user.user_id — NOT NULL

user_scrap (Untitled7)

  • user_scrap_id (Key3) — uuid — 기본 키 — NOT NULL
  • user_id (Key) — uuid — 외래 키 → user.user_id — NOT NULL
  • article_id (Key2) — uuid — 외래 키 → meeting.meeting_id — NOT NULL