같이의 가치

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