abc
Tables (8)
attachments
- id — NUMBER
- post_id — NUMBER — Foreign key → posts.id
- file_path — VARCHAR2(500)
- original_name — VARCHAR2(255)
- uploaded_at — DATE
boards
- id — NUMBER
- name — VARCHAR2(50)
- description — VARCHAR2(500)
comments
- id — NUMBER
- post_id — NUMBER — Foreign key → posts.id
- user_id — NUMBER — Foreign key → users.id
- parent_id — NUMBER — Foreign key → comments.id
- content — VARCHAR2(1000)
- created_at — DATE
customer
- cid — NUMBER(3)
- cname — VARCHAR2(30)
- mobile — VARCHAR2(15)
- address — VARCHAR2(100)
- accum_pur_amt — NUMBER(10,1)
- clevel — CHAR(1) — Foreign key → customer_level.level_code
customer_level
- level_code — CHAR(1)
- level_name — VARCHAR2(20)
- discount_rate — NUMBER(3,2)
likes
- user_id — NUMBER — Foreign key → users.id
- post_id — NUMBER — Foreign key → posts.id
- created_at — DATE
posts
- id — NUMBER
- board_id — NUMBER — Foreign key → boards.id
- user_id — NUMBER — Foreign key → users.id
- title — VARCHAR2(200)
- content — CLOB
- view_count — NUMBER
- created_at — DATE
- updated_at — DATE
users
- id — NUMBER
- email — VARCHAR2(100)
- password_hash — VARCHAR2(255)
- nickname — VARCHAR2(50)
- role — VARCHAR2(20)
- created_at — DATE