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)