캠퍼스밋
테이블 (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