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