같이의 가치
테이블 (8)
Copy Of Untitled (group_approval)
- Key (group_approval_id) — Long — 기본 키 — NOT NULL
- user_id — Long — 외래 키 → user.user_id — NOT NULL
- Key (group_id) — Long — 외래 키 → Untitled.Key — NOT NULL
- Field (approval_sataus) — varchar
- Field (approved_date_time) — DATETIME
- Field (is_deleted) — boolean
- Field (created_date_time) — DATETIME
- Field (updated_date_time) — DATETIME
Copy Of Untitled2 (chat_room)
- Key (chat_room_id) — Long — 기본 키 — NOT NULL
- Field (title) — varchar
- Field (is_deleted) — boolean
- Field (created_date_time) — DATETIME
- Field (updated_date_time) — DATETIME
Untitled (group_member)
- Key (group_member_id) — Long — 기본 키 — NOT NULL
- user_id — Long — 외래 키 → user.user_id — NOT NULL
- Key (group_id) — Long — 외래 키 → Untitled.Key — NOT NULL
- Key (chat_room_id) — Long — 외래 키 → Copy Of Untitled2.Key — NOT NULL
- Field (member_role) — varchar
- Field (exit_type) — varchar
- Field (is_deleted) — boolean
- Field (created_date_time) — DATETIME
- Field (updated_date_time) — DATETIME
Untitled (group)
- Key (group_id) — Long — 기본 키 — NOT NULL
- Field (name) — varchar
- Field (content) — varchar
- Field (max_member_number) — INT
- Field (trip_area) — varchar
- Field (trip_date) — DATE
- Field (due_date) — DATE
- Field (is_deleted) — boolean
- Field (created_date_time) — DATETIME
- Field (updated_date_time) — DATETIME
Untitled (trip_place)
- Key (trip_place_id) — Long — 기본 키 — NOT NULL
- Key (group_id) — Long — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — varchar
- Field (address_point) — POINT
- Field (address) — varchar
- Field (order) — INT
Untitled (message)
- Key (chat_room_id) — Long — 기본 키 — NOT NULL
- Key (message_id) — Long — 기본 키 — NOT NULL
- user_id — Long — 외래 키 → Untitled.user_id — NOT NULL
- Key (group_id) — Long — 외래 키 → Untitled.Key — NOT NULL
- Field (message) — varchar
- Field (send_date_time) — varchar
Untitled (alarm)
- Key (group_id) — Long — 기본 키 — NOT NULL
- Key2 (alarm_id) — Long — 기본 키 — NOT NULL
- user_id — Long — 외래 키 → Untitled.user_id — NOT NULL
- Field (message) — varchar
- Field2 (read_date_time) — DATETIME
- Field3 (is_deleted) — boolean
- Field4 (created_date_time) — DATETIME
- Field (updated_date_time) — DATETIME
user
- user_id — Long — 기본 키 — NOT NULL
- Field (email) — varchar — unique
- Field (password) — varchar
- Field (nickname) — varchar
- Field (age) — INT
- Field (gender) — varchar
- Field (profile_url) — varchar
- Field (regited_type) — varchar
- Field (is_deleted) — boolean
- Field (created_date_time) — DATETIME
- Field (updated_date_time) — DATETIME