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