캠퍼스밋

테이블 (14)

Untitled (Card)

  • Key (card_id) — int — 기본 키 — NOT NULL
  • Field (type) — varchar

Untitled (Presented Cards)

  • Key (user_id) — int — 기본 키 — NOT NULL
  • Key (card_id) — int — 기본 키 — NOT NULL
  • Field (num) — int

Untitled (Post (Not yet))

  • Key (post_id) — int — 기본 키 — NOT NULL
  • Field (author_id) — int
  • Field (title) — varchar
  • Field (region_id) — int
  • Field (created_at) — date
  • Field (updated_at) — date
  • Field (deleted_at) — date
  • Field (date) — date

Untitled (Meeting (In progress))

  • Key (meeting_id) — int — 기본 키 — NOT NULL
  • Field (date) — date
  • Field (title) — varchar
  • Field (created_at) — date
  • Field (updated_at) — date
  • Field (deleted_at) — date

Untitled (Post Members)

  • Key (post_id) — int — 기본 키 — NOT NULL
  • Key (member_id) — int — 기본 키 — NOT NULL

Untitled (Region)

  • Key (region_id) — int — 기본 키 — NOT NULL
  • Field (region) — varchar

Untitled (Keyword)

  • Key (keyword_id) — int — 기본 키 — NOT NULL
  • Field (keyword) — varchar

Untitled (Post Keywords)

  • Key (post_id) — int — 기본 키 — NOT NULL
  • Key (keyword_id) — int — 기본 키 — NOT NULL

Untitled (Post Likes)

  • Key (user_id) — int — 기본 키 — NOT NULL
  • Key (post_id) — int — 기본 키 — NOT NULL

Untitled (Presented Cards2)

  • Key (user_id) — int — 기본 키 — NOT NULL
  • Field (card1) — int
  • Field (card2) — int
  • Field (card3) — int
  • Field (card4) — int
  • Field (card5) — int

Untitled (Meeting Members)

  • Key (meeting_id) — int — 기본 키 — NOT NULL
  • Key (member_id) — int — 기본 키 — NOT NULL

Untitled (Notification)

  • Key (noti_id) — int — 기본 키 — NOT NULL
  • Key (user_id) — int — 기본 키 — NOT NULL
  • Field (type) — varchar
  • Field (text) — varchar

Untitled (Point)

  • Key (point_id) — int — 기본 키 — NOT NULL
  • Field (user_id) — int
  • Field (type) — varchar
  • Field (point) — int

User

  • Key (user_id) — int — 기본 키 — NOT NULL
  • Field (name) — varchar
  • Field (id) — varchar
  • Field (pw) — varchar
  • Field (picture) — varchar
  • Field (birth) — date
  • Field (university) — varchar
  • Field (class) — int
  • Field (nickname) — varchar
  • Field (preference) — varchar
  • Field (point) — int
  • Field (created_at) — date
  • Field (updated_at) — date
  • Field (deleted_at) — date