Fitmate2
Tables (16)
Admin
- adminNo — bigint — Primary key — NOT NULL
- email — varchar(50) — NOT NULL
- password — varchar(20) — NOT NULL
- nickname — varchar(10) — NOT NULL
Answer
- answerNo — bigint — Primary key — NOT NULL
- qnaNo — bigint — NOT NULL
- adminNo — bigint — NOT NULL
- content — varchar(1000) — NOT NULL
- createdAt — DATETIME — NOT NULL
Comment
- commentNo — bigint — Primary key — NOT NULL
- memberNo — bigint — NOT NULL
- styleNo — bigint — NOT NULL
- content — varchar(500)
- createdAt — DATETIME
Image
- imageNo — bigint — Primary key — NOT NULL
- imageURL — varCHAR(200)
Member
- memberNo — bigINT — Primary key — NOT NULL
- email — varchar(50) — NOT NULL
- password — varchar(20) — NOT NULL
- nickname — varchar(10) — NOT NULL
- name — varchar(20) — NOT NULL
- gender — tinyINT — NOT NULL
- thumnail — bigint — NOT NULL
- phone — varchar(11)
- height — INT
- weight — INTEGER
- top — INTEGER
- bottom — INT
- shoesize — INT
MemberTag
- memberNo — bigint — NOT NULL
- tagNo — bigint
Order
- OrderNo — bigint — Primary key — NOT NULL
- stylistNo — bigint — Foreign key → Stylist.stylistNo — NOT NULL
- memberNo — bigint — Foreign key → Member.memberNo — NOT NULL
- cost — int
- createdAt — DATETIME
- reservationDate — DATETIME
Portfolio
- portfolioNo — bigint — Primary key — NOT NULL
- stylistNo — bigint — NOT NULL
- about — varchar(1000)
QnA
- qnaNo — bigint — Primary key — NOT NULL
- memberNo — bigint — NOT NULL
- title — varchar(50)
- content — varchar(500)
- createdAt — DATETIME
- isAnswered — BOOLEAN
Review
- reviewNo — bigint — Primary key — NOT NULL
- memberNo — bigint — NOT NULL
- portfolioNo — bigint — NOT NULL
- imageNo — bigint — NOT NULL
- content — varchar(500)
- rate — int — NOT NULL
- createdAt — DATETIME
Style
- styleNo — bigint — Primary key — NOT NULL
- portfolioNo — bigint — NOT NULL
- imageNo — bigint — NOT NULL
- image — bigint
- content — varchar(500)
- createdAt — DATETIME
StyleTag
- styleNo — bigint — NOT NULL
- tagNo — bigint
Stylist
- stylistNo — bigINT — Primary key — NOT NULL
- email — varchar(50) — NOT NULL
- nickname — varchar(10) — NOT NULL
- password — varchar(20) — NOT NULL
- name — varchar(20) — NOT NULL
- gender — tinyint — NOT NULL
- phone — varchar(11)
- thumnail — bigint — NOT NULL
StylistTag
- TagNo — bigint — NOT NULL
- stylistNo — bigint — NOT NULL
Tag
- tagNo — bigint — NOT NULL
- Tag — varchar(30) — NOT NULL
notice
- noticeNo — bigint — Primary key — NOT NULL
- adminNo — bigint — NOT NULL
- memberNo — bigint — NOT NULL
- title — varchar(50)
- content — varchar(500)
- createdAt — DATETIME