B303

Tables (15)

Animal (동물)

  • AnimalId (animalId) — VARCHAR(100) — Primary key — NOT NULL
  • Name (name) — VARCHAR(100)
  • Picture (picture) — VARCHAR(500)
  • Specie (specie) — VARCHAR(100)
  • Age (age) — VARCHAR(10)
  • Note (note) — VARCHAR(1000)
  • Weight (weight) — DECIMAL
  • Gender (gender) — VARCHAR(10)
  • UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL

ExpertUser (전문가)

  • LicenseNumber (license) — VARCHAR(20) — Primary key
  • Note (note) — VARCHAR(1000)
  • StartTime (startTime) — TIME
  • EndTime (endTime) — TIME
  • UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
  • HospitalNo (hosno) — INT — Foreign key → HospitalData.HospitalNo

HospitalData (동물병원 정보)

  • HospitalNo (hosno) — INT — Primary key
  • ManageNo (manageno) — INT
  • Phone (phone) — VARCHAR(30)
  • LotNumberAddress (lotAddr) — VARCHAR(500)
  • RoadNumberAddress (roadAddr) — VARCHAR(500)
  • PostalNumber (posNum) — INT
  • Name (name) — VARCHAR(200)
  • Longitude (long) — VARCHAR(100)
  • Latitude (lat) — VARCHAR(100)

Messages (쪽지)

  • MessageId (mesId) — INT — Primary key — NOT NULL
  • Time (time) — DATETIME
  • Title (title) — VARCHAR(200)
  • Content (content) — VARCHAR(1000)
  • From (from) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
  • To (to) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL

ParticipantHistory (참여기록)

  • UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
  • RoomId (roomId) — VARCHAR(100) — Foreign key → VideoRoom.RoomId — NOT NULL
  • EnterTime (enterTime) — DATETIME

PostComment (게시판댓글)

  • CommentNo (commentNo) — INT — Primary key — NOT NULL
  • Content (content) — VARCHAR(1000)
  • RegistTime (registTime) — DATETIME
  • PostId (postId) — VARCHAR(100) — Foreign key → UserPost.PostId — NOT NULL
  • UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL

PostFiles (게시판파일)

  • URL (url) — VARCHAR(1000)
  • FileName (fileName) — VARCHAR(200)
  • PostId (postId) — VARCHAR(100) — Foreign key → UserPost.PostId — NOT NULL

QnABoard (QnA게시판)

  • PostId (postId) — VARCHAR(100) — Primary key — NOT NULL
  • Title (title) — VARCHAR(200)
  • Content (content) — VARCHAR(1000)
  • RegistTime (registTime) — DATETIME
  • UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL

Reservation (예약)

  • AppointId (appointId) — VARCHAR(100) — Primary key — NOT NULL
  • Time (time) — DATETIME
  • Diagnosis (diagnosis) — VARCHAR(1000) — NOT NULL
  • Note (note) — VARCHAR(1000)
  • Type (type) — INT
  • UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
  • LicenseNumber (license) — VARCHAR(20) — Foreign key → ExpertUser.LicenseNumber
  • HospitalNo (hosno) — INT — Foreign key → HospitalData.HospitalNo

User (사용자)

  • UserId (userId) — VARCHAR(100) — Primary key — NOT NULL
  • Password (password) — VARCHAR(50)
  • UserName (username) — VARCHAR(50)
  • Address (address) — VARCHAR(500)
  • Phone (phone) — VARCHAR(20)
  • Type (type) — INT
  • Picture (picture) — VARCHAR(500)

UserPost (자유게시판)

  • PostId (postId) — VARCHAR(100) — Primary key — NOT NULL
  • Hits (hits) — INT
  • Content (content) — VARCHAR(1000)
  • Likes (likes) — INT
  • RegistTime (registTime) — DATETIME
  • UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL

VenueData (편의시설 정보)

  • DataNo (datano) — INT — Primary key — NOT NULL
  • VenueName (venName) — VARCHAR(100)
  • Category (category) — VARCHAR(50)
  • Sido (sido) — VARCHAR(50)
  • Gungu (gungu) — VARCHAR(50)
  • MyunDong (myundong) — VARCHAR(50)
  • Latitude (lat) — DECIMAL
  • Longitude (long) — DECIMAL
  • PostalNumber (posNum) — INT
  • RoadNumberAddress (roadAddr) — VARCHAR(500)
  • LotNumberAddress (lotAddr) — VARCHAR(500)
  • Phone (phone) — VARCHAR(30)
  • HomePage (homepage) — VARCHAR(200)
  • OffTime (offTime) — VARCHAR(200)
  • WorkTime (workTime) — VARCHAR(200)
  • ParkingAvailability (parkAvail) — CHAR(4)
  • EntranceAvailibility (entrAvail) — VARCHAR(100)
  • Limitations (limit) — VARCHAR(100)

Verification (인증정보)

  • UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
  • VerificationCode (verCode) — VARCHAR(10)
  • CodeTimer (codeTime) — DATETIME

VideoChatLog (화상채팅기록)

  • RoomId (roomId) — VARCHAR(100) — Foreign key → VideoRoom.RoomId — NOT NULL
  • URL (url) — VARCHAR(1000)

VideoRoom (화상 방 정보)

  • RoomId (roomId) — VARCHAR(100) — Primary key — NOT NULL
  • StartTime (startTime) — DATETIME
  • RoomName (roomName) — VARCHAR(100)
  • Note (note) — VARCHAR(1000)
  • UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL