groomthon

Tables (5)

Comment

  • id — BIGINT — Primary key — NOT NULL
  • divelog_id — BIGINT — Foreign key → DiveLog.id — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • content — VARCHAR

DiveLog

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • adress — VARCHAR
  • latitude — DOUBLE
  • longitude — DOUBLE
  • image_url — VARCHAR
  • dive_type — VARCHAR
  • score — VARCHAR
  • review — VARCHAR
  • approach_type — VARCHAR
  • surface_flow — VARCHAR
  • deep_flow — VARCHAR
  • temp — DOUBLE
  • water_temp — DOUBLE
  • before_tank — INT
  • after_tank — INT
  • dive_depth — INT
  • point_depth — INT
  • dive_at — DATETIME
  • dive_time — INT
  • decompression_time — INT
  • distance_view — INT
  • is_public — BOOLEAN

HashTag

  • id — BIGINT — Primary key — NOT NULL
  • divelog_id — BIGINT — Foreign key → DiveLog.id — NOT NULL
  • name — VARCHAR

User

  • id — BIGINT — Primary key — NOT NULL
  • nick_name — VARCHAR
  • image_url — VARCHAR
  • email — VARCHAR
  • role_type — VARCHAR
  • kakao_id — VARCHAR
  • created_at — DATETIME
  • modified_at — DATETIME

UserLike

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • divelog_id — BIGINT — Foreign key → DiveLog.id — NOT NULL