fitChk

Tables (5)

categories

  • category_id — NUMBER — Primary key — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • season — VARCHAR2(20)
  • style_tag — VARCHAR2(50)

likes

  • like_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key — NOT NULL
  • post_id — NUMBER — Foreign key → posts.post_id — NOT NULL
  • created_at — DATE

post_items

  • item_id — NUMBER — Primary key — NOT NULL
  • post_id — NUMBER — Foreign key → posts.post_id — NOT NULL
  • brand — VARCHAR2(100)
  • product_name — VARCHAR2(200)
  • price — NUMBER(10)
  • purchase_url — VARCHAR2(500)
  • pos_x — NUMBER(5, 2) — NOT NULL
  • pos_y — NUMBER(5, 2) — NOT NULL
  • created_at — DATE

posts

  • post_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key — NOT NULL
  • category_id — NUMBER — Foreign key → categories.category_id — NOT NULL
  • title — VARCHAR2(100) — NOT NULL
  • content — CLOB
  • image_url — VARCHAR2(500)
  • like_count — NUMBER(10)
  • created_at — DATE
  • updated_at — DATE

refreshToken

  • login_id — NOT NULL — Primary key — NOT NULL
  • RT_value (rt_value) — NOT NULL