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