ㅇㄹㅇㄹ

Tables (4)

AuctionMessage

  • roomid — VARCHAR — Primary key — NOT NULL
  • 메시지 (message) — VARCHAR
  • 시간 (time) — TIMESTEMP
  • 송신자 (sender) — MEMBER — Foreign key → Member.id — NOT NULL

Chatmessage (ChatMessage)

  • roomid — VARCHAR — Primary key — NOT NULL
  • 메시지 (message) — VARCHAR
  • 시간 (time) — TIMESTEMP
  • 송신자 (sender) — MEMBER — Foreign key → Member.id — NOT NULL

Horse

  • id — Long — Primary key — NOT NULL
  • 말 이름 (name) — VARCHAR — NOT NULL
  • 고유번호 (uniqueNum) — VARCHAR
  • 생일 (birth) — VARCHAR — NOT NULL
  • furcolor — VARCHAR — NOT NULL
  • 낙찰가 (bidPrice) — LONG — NOT NULL
  • 소유자 (owner) — MEMBER — Foreign key → Member.id — NOT NULL
  • 생산자 (producer) — MEMBER — Foreign key → Member.id — NOT NULL
  • 부마 (father) — HORSE — Foreign key → Horse.id — NOT NULL
  • 모마 (mother) — HORSE — Foreign key → Horse.id — NOT NULL

Member

  • id — Long — Primary key — NOT NULL
  • 이름 (name) — VARCHAR
  • 휴대전화 (phone) — VARCHAR
  • 비밀번호 (password) — VARCHAR
  • 아이디 (username) — VARCHAR
  • 유저 role (role) — Role