연습
테이블 (18)
ADMIN
- admin_id — INT
- admin_name — VARCHAR(100)
- password — VARCHAR(255)
- email — VARCHAR(255)
ARTICLE
- article_id — INT
- title — VARCHAR(255)
- content — TEXT
- published_date — DATE
- location_id — INT
- crawled_source_url — VARCHAR(255)
CATEGORY
- category_id — INT
- name — VARCHAR(100)
- image_url — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- status — VARCHAR(50)
COMMUNITY_POST
- post_id — INT
- user_id — INT
- title — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- status — VARCHAR(50)
- post_date — DATE
- content — TEXT
- view_count — INT
- tag_id — INT
- location_id — INT
ENDPOST
- endpost_id — INT
- seller_id — INT
- buyer_id — INT
- post_id — INT
- status — VARCHAR(50)
LOCATION
- location_id — INT
- city_si — VARCHAR(100)
- city_gu — VARCHAR(100)
- city_dong — VARCHAR(100)
NOTICE_POST
- notice_post_id — INT
- admin_id — INT
- title — VARCHAR(255)
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- status — VARCHAR(50)
NOTIFICATION
- notification_id — INT
- user_id — INT
- content — TEXT
- notification_date — TIMESTAMP
- status — VARCHAR(50)
- type — VARCHAR(50)
POST_TAG_RELATIONSHIP
- relationship_id — INT
- post_id — INT
- tag_id — INT
PRODUCT_POST
- post_id — INT
- user_id — INT
- title — VARCHAR(255)
- price — DECIMAL(10, 2)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- status — VARCHAR(50)
- post_date — DATE
- category_id — INT
- content — TEXT
- view_count — INT
- tag_id — INT
- location_id — INT
REPORTED_POST
- reported_id — INT
- user_id — INT
- post_id — INT
- reported_date — TIMESTAMP
- status — VARCHAR(50)
- content — TEXT
TAG
- tag_id — INT
- tag_name — VARCHAR(100)
USER
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
Untitled2
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
Untitled3
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
Untitled5
- PK — VARCHAR(255) — 기본 키 — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field8 — VARCHAR(255)
- Field9 — VARCHAR(255)
WISHLIST
- wish_id — INT
- user_id — INT
- post_id — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- status — VARCHAR(50)