POCSIN

Tables (7)

Board

  • bno — number(10, 0)
  • id — varchar2(20)
  • title — varchar2(200) — NOT NULL
  • content — varchar2(2000) — NOT NULL
  • writer — varchar2(50) — NOT NULL
  • viewcnt — number
  • replycnt — number
  • regdate — date
  • updatedate — date

Board_reply

  • rno — number(10, 0)
  • bno — number(10, 0) — Foreign key → Board.bno — NOT NULL
  • reply — varchar2(1000) — NOT NULL
  • replyer — varchar2(50) — NOT NULL
  • replydate — date
  • updatedate — date

MEMBER

  • ID — VARCHAR2(40)
  • PW — VARCHAR2(40) — NOT NULL
  • EMAIL — VARCHAR2(50) — NOT NULL
  • NAME — VARCHAR2(40) — NOT NULL
  • POST_NUM — VARCHAR2(20)
  • PHONE_NUM — VARCHAR2(20)
  • ADDRESS — VARCHAR2(100)

Notice

  • noticebno — number(10, 0)
  • admin — varchar2(50) — NOT NULL
  • title — varchar2(200) — NOT NULL
  • content — varchar2(2000) — NOT NULL
  • regdate — date

Pay

  • per_num (per_num2) — varchar2(50) — Foreign key → product.per_num — NOT NULL
  • pay_id — varchar2(50) — NOT NULL
  • per_time — date
  • import_id — varchar2(50)
  • per_num — varchar2(50)
  • pname — varchar2(100)
  • pay_amount — int
  • pcount — varchar2(50)
  • pbuyer — varchar2(50)
  • padress — varchar2(150)

product

  • per_num — varchar2(50) — Primary key — NOT NULL
  • pbrand — VARCHAR2(100)
  • pname — VARCHAR2(50)
  • pdiscount — VARCHAR2(50)
  • pay_amount — int
  • category — VARCHAR2(50)
  • pimage — VARCHAR2(500)

question

  • qno — NUMBER(10,0) — Primary key — NOT NULL
  • type — VARCHAR2(50) — NOT NULL
  • writer — VARCHAR2(25) — NOT NULL
  • contactnumber — VARCHAR2(25) — NOT NULL
  • content — VARCHAR2(2000) — NOT NULL
  • regdate — date