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