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