CheerMuk

Tables (8)

article_bookmarks (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → members.id — NOT NULL
  • article_id (Key3) — bigint — Foreign key → articles.id — NOT NULL
  • created_at (Field) — timestamp — NOT NULL

article_comments (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → members.id — NOT NULL
  • article_id (Key3) — bigint — Foreign key → articles.id — NOT NULL
  • content (Field) — text — NOT NULL
  • parent_comment_id (Field4) — bigint
  • created_at (Field2) — timestamp — NOT NULL
  • modified_at (Field3) — timestamp

article_images (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • article_id (Key2) — bigint — Foreign key → articles.id — NOT NULL
  • img_url (Field) — text — NOT NULL
  • created_at (Field2) — timestamp — NOT NULL
  • modified_at (Field3) — timestamp

article_likes (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → members.id — NOT NULL
  • article_id (Key3) — bigint — Foreign key → articles.id — NOT NULL
  • created_at (Field) — timestamp — NOT NULL

article_reports (Untitled8)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → members.id — NOT NULL
  • article_id (Key3) — bigint — Foreign key → articles.id — NOT NULL
  • report_type (Field) — varchar(100) — NOT NULL
  • created_at (Field2) — timestamp — NOT NULL

articles (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → members.id — NOT NULL
  • restaurant_id (Key3) — bigint — Foreign key → restaurants.id — NOT NULL
  • title (Field) — text — NOT NULL
  • content (Field2) — text — NOT NULL
  • view_cnt (Field9) — bigint — NOT NULL
  • like_cnt (Field10) — bigint — NOT NULL
  • rate (Field11) — smallint[3] — NOT NULL — taste_rate, price_rate, service_rate
  • created_at (Field3) — timestamp — NOT NULL
  • modified_at (Field4) — timestamp
  • deleted_at (Field5) — timestamp

members (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • nickname (Field) — varchar(255) — NOT NULL
  • img_url (Field2) — text
  • user_role (Field6) — varchar(10) — NOT NULL
  • created_at (Field3) — timestamp — NOT NULL
  • modified_at (Field4) — timestamp
  • deleted_at (Field5) — timestamp

restaurants (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field9) — varchar(255) — NOT NULL — 식당명
  • jibun_address (Field3) — jsonb — 지번 주소(구주소): 시도, 시군구, 읍명동, 지번, 상세주소, 우편번호
  • road_addres (Field4) — json — 도로명 주소: 주소, 도로우편번호
  • latitude (Field5) — decimal(10, 8) — 위도(x)
  • longitude (Field6) — decimal(11, 8) — 경도(y)
  • biz_type (Field10) — varchar(100) — NOT NULL — 업태유형
  • link (Field8) — text — 식당 정보관련 URL
  • created_at (Field) — timestamp — NOT NULL
  • modified_at (Field2) — timestamp
  • deleted_at (Field7) — timestamp