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