1515

Tables (7)

USER_blog_category (kdh9145_blog_category)

  • no — number — Primary key — NOT NULL
  • category — varchar2(20 char)

USER_blog_like (kdh9145_blog_like)

  • post_no — number — NOT NULL
  • click_id — varchar2(20 char) — NOT NULL

USER_blog_neighbor (kdh9145_blog_neighbor)

  • n_id — varchar2(20 char) — Primary key — NOT NULL
  • no — number
  • reg_date — date — NOT NULL
  • comments — varchar2(100 char)

USER_blog_post (kdh9145_blog_post)

  • no — number — Primary key
  • category — varchar2(20 char) — NOT NULL
  • title — varchar2(100 CHAR) — NOT NULL
  • content — varchar2(4000 char) — NOT NULL
  • reg_date — date — NOT NULL
  • like_num — number

blog

  • no — number — Primary key — NOT NULL
  • id — varchar2(20 char) — NOT NULL
  • blog_title — varchar2(50 char) — NOT NULL
  • blog_title_img — varchar2(1000 char)
  • blog_title_color — varchar2(20 char)
  • blog_bg — varchar2(1000 char)
  • profile_name — varchar2(20 char) — NOT NULL
  • profile_msg — varchar2(100 char) — NOT NULL
  • profile_img — varchar2(1000 char)
  • visit_count — number

blog_member

  • id — varchar2(20 char) — Primary key
  • no — number
  • name — varchar2(20 char) — NOT NULL
  • pass — varchar2(1000 CHAR) — NOT NULL
  • email — varchar2(50 char) — NOT NULL
  • postnum — number(5) — NOT NULL
  • address1 — varchar2(50 char) — NOT NULL
  • address2 — varchar2(50 char) — NOT NULL
  • reg_date — date — NOT NULL

reply

  • no — number — Primary key
  • writer_id — varchar2(20 char) — NOT NULL
  • post_id — varchar2(20 char) — NOT NULL
  • post_no — number — NOT NULL
  • content — varchar2 — NOT NULL
  • private — varchar2(5 char)
  • false)) — not — NOT NULL
  • reg_date — date — NOT NULL