simsang0809

Tables (14)

community

  • num — number — Primary key — NOT NULL
  • membernum — number — NOT NULL
  • name — varchar2(50) — NOT NULL
  • people — number
  • favorite — number
  • communitydate — date — NOT NULL

diary

  • num — NUMBER
  • membernum — NUMBER — Foreign key → member.num — NOT NULL
  • emotion — VARCHAR2(50) — NOT NULL
  • week — VARCHAR2(50) — NOT NULL
  • title — VARCHAR2(50) — NOT NULL
  • content — VARCHAR2(50) — NOT NULL
  • diarydate — DATE — NOT NULL
  • diaryupdate — DATE
  • imagePath — VARCHAR2(2000)
  • image — VARCHAR2(2000)

emotion

  • num — number — Primary key — NOT NULL
  • resultnum — number — NOT NULL
  • membernum — number — NOT NULL
  • name — varchar2(50) — NOT NULL
  • score — float — NOT NULL

hashtag

  • num — number — Primary key — NOT NULL
  • communitunum — number — NOT NULL
  • name — varchar2(50) — NOT NULL

member

  • num — number — Primary key — NOT NULL
  • id — varchar2(50) — NOT NULL
  • pwd — varchar2(50) — NOT NULL
  • nick — varchar2(50) — NOT NULL
  • email — varchar2(50) — NOT NULL
  • tel — varchar2(50) — NOT NULL
  • address — varchar2(50) — NOT NULL
  • detailaddress — varchar2(50) — NOT NULL
  • mdate — date — NOT NULL
  • name — varchar2(50)
  • age — varchar2(50)
  • gender — varchar2(50)
  • imgn — VARCHAR2(50)

qnaanswer

  • num — number — Primary key — NOT NULL
  • qnanum — number — NOT NULL
  • content — varchar2(50) — NOT NULL
  • qnaanswerdate — date — NOT NULL

qnaquestion

  • num — NUMBER — Primary key — NOT NULL
  • membernum — NUMBER
  • name — varchar2(50) — NOT NULL
  • qnaquestiondate — date — NOT NULL
  • category — varchar2(50) — NOT NULL
  • title — varchar2(50) — NOT NULL
  • content — varchar2(50) — NOT NULL
  • imgname — varchar2(100)
  • status — varchar2(100)

questionnaire

  • num — NUMBER
  • question — VARCHAR2(300) — NOT NULL
  • cause — VARCHAR2(100) — NOT NULL
  • description — VARCHAR2(100) — NOT NULL

report

  • num — number — Primary key — NOT NULL
  • comunicationnum — number — NOT NULL
  • communitunum — number — NOT NULL
  • membernum — number — NOT NULL
  • content — varchar2(50)
  • reportdate — date

result

  • num — number — Primary key — NOT NULL
  • membernum — number — NOT NULL
  • testspecies — varchar2(50) — NOT NULL
  • testcategory — varchar2(50) — NOT NULL
  • testvideotext — varchar2(50)
  • simulationprofile — varchar2(50)
  • simulationresult — varchar2(50)
  • selfquestionresult — varchar2(50)
  • htpimgname — varchar2(50)
  • htpresult — varchar2(50)
  • testdate — date — NOT NULL

simulation

  • num — NUMBER — Primary key — NOT NULL
  • membernum — NUMBER — NOT NULL
  • category — VARCHAR2(50) — NOT NULL
  • type — VARCHAR2(50) — NOT NULL
  • simuldate — DATE — NOT NULL
  • title — VARCHAR2(255) — NOT NULL

simuldialog

  • num — NUMBER — Primary key — NOT NULL
  • simulationnum — NUMBER — NOT NULL
  • conversation — VARCHAR2(255) — NOT NULL
  • status — VARCHAR2(10)

talk

  • num — number — Primary key — NOT NULL
  • communitunum — number — NOT NULL
  • membernum — number — NOT NULL
  • content — varchar2(50) — NOT NULL
  • talkdate — date — NOT NULL

useresponse

  • id — NUMBER
  • userid — VARCHAR2(50)
  • surveycode — VARCHAR(50)
  • qnum — NUMBER
  • respscore — number
  • respdate — DATE