chatHealth-final
Tables (19)
Board (board)
- board_id — number — Primary key — NOT NULL
- member_id — number — Foreign key → Member.member_id — NOT NULL
- title — varchar2(2000) — NOT NULL
- content — clob — NOT NULL
- category — varchar2(200)
- created_date — date
- modified_date — date
- deleted_date — date
BoardComment
- boardcomment_id — number — Primary key — NOT NULL
- board_id — number — Foreign key → Board.board_id — NOT NULL
- member_id — number — Foreign key → Member.member_id — NOT NULL
- content — varchar2(2000)
- created_date — date
- modified_date — date
- deleted_date — date
BoardHit
- hit_id — number — Primary key — NOT NULL
- board_id — number — Foreign key → Board.board_id — NOT NULL
- member_id — number — Foreign key → Member.member_id — NOT NULL
ChatMessage
- chat_message_id — number — Primary key — NOT NULL
- room_id — number — Foreign key → ChatRoom.room_id — NOT NULL
- room_member_id — number — Foreign key → ChatRoomMember.room_member_id — NOT NULL
- message
- timestamp — date
- type — varcahr2(200)
ChatRoom
- room_id — number — Primary key — NOT NULL
- represintative_member (member_id) — number — Foreign key → Member.member_id — NOT NULL
- name — varchar2(200)
- description — varchar2(1000)
- room_image — varchar2(200)
ChatRoomMember
- room_member_id — number — Primary key — NOT NULL
- room_id — number — Foreign key → ChatRoom.room_id — NOT NULL
- member_id — number — Foreign key → Member.member_id — NOT NULL
- chat_nickname — varchar2(200)
- deleted_date (delete_date) — date
Helpful
- helpful_id — number — Primary key — NOT NULL
- review_id — number — Foreign key → Review.review_id — NOT NULL
- member_id — number — Foreign key → Member.member_id — NOT NULL
Like
- like_id — number — Primary key — NOT NULL
- boardcomment_id — number — Foreign key → BoardComment.boardcomment_id — NOT NULL
- member_id — number — Foreign key → Member.member_id — NOT NULL
Marerial (Material)
- material_id — number — Primary key — NOT NULL
- symptom_id — number — Foreign key → Symptom.symptom_id — NOT NULL
- material_name — varchar2(1000)
- functions — varchar2(5000)
MarerialPost (MaterialPost)
- mp_id — number — Primary key — NOT NULL
- post_id — number — Foreign key → Post.post_id — NOT NULL
- material_id — number — Foreign key → Marerial.material_id — NOT NULL
Member
- member_id — number — Primary key — NOT NULL
- email — varchar2(150) — NOT NULL — unique
- pw — varchar2(150) — NOT NULL
- nickname — varchar2(150)
- name — varchar2(150)
- company — varchar2(255)
- ent_no — varchar2(150)
- ceo — varchar2(150)
- addressa (address) — varchar2(1000)
- birth — date
- address_detail — varchar2(1000)
- profile — varchar2(1000)
- role — varchar2(150) — NOT NULL
- grade — varchar2(150) — NOT NULL
- created_date — date
- modified_date — date
- deleted_date — date
- DTYPE — varchar2(31)
Message
- message_id — number — Primary key — NOT NULL
- member_id (sender_id) — number — Foreign key → Member.member_id — NOT NULL
- member_id (receiver_id) — number — Foreign key → Member.member_id — NOT NULL
- is_read — number
- created_date — date
- modified_date — date
- deleted_date — date
PicturePost (postimg)
- picture_id (pictire_id) — number — Primary key — NOT NULL
- post_id — number — Foreign key → Post.post_id — NOT NULL
- picture_url — varchar2(2000)
- orders — number
Post (post)
- post_id — number — Primary key — NOT NULL
- member_id — number — Foreign key → Member.member_id — NOT NULL
- title — varchar2(2000)
- content — clob
- created_date — date
- modified_date — date
- deleted_date — date
- symptom_id — number — Foreign key → Symptom.symptom_id — NOT NULL
PostHit
- hit_id — number — Primary key — NOT NULL
- post_id — number — Foreign key → Post.post_id — NOT NULL
- member_id — number — Foreign key → Member.member_id — NOT NULL
PostLike
- id — number — Primary key — NOT NULL
- member_id — number — Foreign key → Member.member_id — NOT NULL
- post_id — number — Foreign key → Post.post_id — NOT NULL
ReComment
- recomment_id — number — Primary key — NOT NULL
- review_id — number — Foreign key → Review.review_id — NOT NULL
- member_id — number — Foreign key → Member.member_id — NOT NULL
- content — CLOB
- created_date — date
- modified_date — date
- deleted_date — date
Review
- review_id — number — Primary key — NOT NULL
- post_id — number — Foreign key → Post.post_id — NOT NULL
- member_id — number — Foreign key → Member.member_id — NOT NULL
- content — verchar2(2000)
- score — number
- created_date — date
- modified_date — date
- deleted_date — date
Symptom
- symptom_id — number — Primary key — NOT NULL
- symptom_name — varchar2(1000)