테스트

테이블 (3)

account

  • site_id — int — 기본 키 — NOT NULL
  • password — varchar(50)
  • name — varchar(45)
  • phone — varchar(15)
  • email — varchar(31)
  • account_id — varchar(50) — NOT NULL — not null
  • address — varchar(200)
  • ts_create — Timestamp

board

  • id — int — 기본 키 — NOT NULL
  • account_id — varchar(50)
  • name — varchar(45)
  • subject — varchar(100)
  • content — text
  • readcount — int
  • ref — int
  • re_step — int
  • re_level — int
  • reg_date — TImestamp

product

  • id — int — 기본 키 — NOT NULL
  • type_id — int
  • repCd — varchar(13)
  • product_name — varchar(200)
  • company — varchar(45)
  • volume — varchar(10)
  • shape — varchar(10)
  • shape2 — varchar(10)
  • ts_create — Timestamp