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