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