violet
Tables (4)
cust_tbl
- CUST_NO — NUMBER(10,0) — NOT NULL
- CUST_NAME — VARCHAR2(20) — NOT NULL
- CUST_BIRTH — DATE
- CUST_GENDER — VARCHAR2(10) — NOT NULL
- CUST_ID — VARCHAR2(50) — NOT NULL
- CUST_PASSWORD — VARCHAR2(50) — NOT NULL
- CUST_ADDRESS — VARCHAR2(200) — NOT NULL
- CUST_PHONE — VARCHAR2(50) — NOT NULL
- CUST_JOB — VARCHAR2(20) — NOT NULL
- CUST_AREA — VARCHAR2(20) — NOT NULL
- CUST_RELIGION — VARCHAR2(10) — NOT NULL
- CUST_SMOKING — VARCHAR2(10) — NOT NULL
- CUST_DRINKING — VARCHAR2(10) — NOT NULL
- CUST_EXER — VARCHAR2(10) — NOT NULL
- CUST_FOOD — VARCHAR2(10) — NOT NULL
- CUST_PET — VARCHAR2(10) — NOT NULL
- CUST_STUDY — VARCHAR2(10) — NOT NULL
- CUST_HOBBY — VARCHAR2(10) — NOT NULL
- CUST_CHAR — VARCHAR2(10) — NOT NULL
- CUST_PHOTO — VARCHAR2(50) — NOT NULL
- CUST_SAY — VARCHAR2(100)
- CUST_JOINDATE — DATE
notice_tbl
- notice_bno — number(10,0)
- notice_title — varchar2(200) — NOT NULL
- notice_content — varchar2(2000) — NOT NULL
- notice_writer — varchar2(50) — NOT NULL
- regdate — date
- hit — number — NOT NULL
story_reply
- reply_rno — number — NOT NULL
- reply_bno — number
- reply_text — varchar2(50) — NOT NULL
- reply_id — varchar2(50) — NOT NULL
- regdate — date
- updatedate — date
story_tbl
- story_bno — number — NOT NULL
- story_custid — varchar(20)
- story_text — varchar(2000)
- regdate — Date
- updatedate — date