ㅇㄹㅇㄹ
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