GAJE-ERD

Tables (21)

BOOKMARK

  • bookmark_id — INT
  • user_id — INTEGER — NOT NULL
  • post_id — INTEGER — NOT NULL
  • created_at — DATETIME

COMMENT

  • comment_id — INTEGER
  • post_id — INTEGER — NOT NULL
  • user_id — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • mentioned_user_id — INTEGER
  • like_count — INT
  • is_deleted — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

COMMENT_LIKE

  • user_id — INTEGER — Primary key — NOT NULL
  • comment_id — INTEGER — Primary key — NOT NULL
  • created_at — DATETIME

COURSE

  • course_id — INTEGER
  • user_id — INTEGER — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • is_deleted — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

COURSE_PLACE

  • course_place_id — INTEGER
  • course_id — INTEGER — NOT NULL
  • place_id — INTEGER — NOT NULL
  • sequence — INT — NOT NULL
  • estimated_stay_minutes — INT
  • expected_cost — INT
  • note — TEXT
  • is_deleted — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

INQUIRY

  • inquiry_id — INTEGER
  • user_id — INTEGER — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • file_url — VARCHAR(1000)
  • answer — TEXT
  • is_answered — BOOLEAN
  • created_at — DATETIME
  • answered_at — DATETIME

NOTICE

  • notice_id — INTEGER
  • admin_id — INTEGER — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • content — TEXT — NOT NULL
  • is_pinned — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

PLACE

  • place_id — INTEGER
  • name — VARCHAR(200) — NOT NULL
  • address — VARCHAR(300)
  • address_detail — VARCHAR(300)
  • phone — VARCHAR(30)
  • homepage — VARCHAR(1000)
  • description — TEXT
  • content_id — INTEGER
  • content_type_id — INTEGER
  • area_code — INT
  • first_image1 — VARCHAR(1000)
  • first_image2 — VARCHAR(1000)
  • map_level — INT
  • latitude — DECIMAL(20,17)
  • longitude — DECIMAL(20,17)
  • view_count — INT
  • is_deleted — BOOLEAN
  • created_at — DATETIME

PLACE_REVIEW

  • review_id — INTEGER
  • post_id — INTEGER — NOT NULL
  • place_id — INTEGER — NOT NULL
  • stay_duration_minutes — INT
  • short_review — TEXT
  • image_url — VARCHAR(1000)
  • is_deleted — BOOLEAN
  • created_at — DATETIME

PLACE_TAG

  • place_id — INTEGER — Primary key — NOT NULL
  • tag_id — INTEGER — Primary key — NOT NULL

POST

  • post_id — INTEGER
  • user_id — INTEGER — NOT NULL
  • course_id — INTEGER — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • view_count — INTEGER
  • is_deleted — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

POST_HISTORY

  • user_id — INTEGER — Primary key — NOT NULL
  • post_id — INTEGER — Primary key — NOT NULL
  • viewed_at — DATETIME

POST_LIKE

  • user_id — INTEGER — Primary key — NOT NULL
  • post_id — INTEGER — Primary key — NOT NULL
  • created_at — DATETIME

POST_TAG

  • post_id — INTEGER — Primary key — NOT NULL
  • tag_id — INTEGER — Primary key — NOT NULL

TAG

  • tag_id — INTEGER
  • name — VARCHAR(50) — NOT NULL
  • created_at — DATETIME

USER

  • user_id — INTEGER
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • role — vARCHAR(10)
  • age — INTEGER
  • phone — VARCHAR(20)
  • is_deleted — BOOLEAN
  • regist_at — DATETIME
  • last_login_at — DATETIME

favorite

  • member_id — BIGINT
  • post_id — BIGINT
  • created_at — DATETIME

member

  • id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50)
  • age — INT
  • profile_image_url — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

post

  • id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • thumbnail — VARCHAR(255)
  • region — VARCHAR(50)
  • theme — VARCHAR(50)
  • author_id — BIGINT — NOT NULL
  • view_count — INT
  • like_count — INT
  • created_at — DATETIME
  • updated_at — DATETIME

post_plan

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • seq — INT — NOT NULL
  • place_id — VARCHAR(100)
  • lat — DECIMAL(9,6)
  • lng — DECIMAL(9,6)
  • est_time — DATETIME
  • cost — INT

post_record

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • plan_id — BIGINT
  • image_url — VARCHAR(255)
  • review — TEXT
  • created_at — DATETIME