KTJT1

Tables (9)

ADVERTISEMENT (Untitled5)

  • ad_id (PK) — bigint — Primary key — NOT NULL
  • shop_id (FK) — bigint — Foreign key → HAIR_SHOP.shop_id — NOT NULL
  • content (Field) — MEDIUMBLOB
  • start_date (Field2) — datetime
  • end_date (Field3) — datetime

CHAT (Chat)

  • chat_id (PK) — bigint — Primary key — NOT NULL
  • timestamp (Field) — datetime
  • message (Field2) — varchar(20)
  • member_id (FK) — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • designer_id (FK2) — bigint — Foreign key → DESIGNER.designer_id — NOT NULL

DESIGNER (Untitled2)

  • designer_id (PK) — bigint — Primary key — NOT NULL
  • shop_id (FK) — bigint
  • name (Field) — varchar(20)
  • specialzation (Field2) — varchar(20)
  • description (Field3) — varchar(20)

HAIR_SHOP (Untitled3)

  • shop_id (PK) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • address (Field2) — varchar(20)
  • phone_number (Field3) — varchar(20)
  • avg_rating (Field4) — float
  • description (Field5) — varchar(20)

JOB_APPLICATION (Untitled7)

  • application_id (Key) — bigint — Primary key — NOT NULL
  • posting_id (PK) — bigint — Foreign key → JOB_POSTING.posting_id — NOT NULL
  • member_id (PK2) — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • name (Field) — varchar(20)
  • email (Field2) — varchar(20)
  • phone_number (Field3) — varchar(20)
  • address (Field4) — varchar(20)
  • education (Field5) — varchar(20)
  • experience_year (Field6) — int
  • want_day (Field7) — varchar(20)
  • certification (Field8) — varcahr(20)
  • self_introduce (Field9) — varchar(200)
  • picture (Field10) — MEDIUMBLOB

JOB_POSTING (Untitled6)

  • posting_id (PK) — bigint — Primary key — NOT NULL
  • shop_id (PK2) — bigint — Foreign key → HAIR_SHOP.shop_id — NOT NULL
  • title (Field) — varchar(20)
  • description (Field2) — varchar(20)
  • posting_date (Field3) — datetime

MEMBER (Untitled)

  • member_id (PK) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • email (Field2) — varchar(20)
  • password (Field3) — varchar(20)
  • phone_nuber (Field4) — varchar(20)
  • location (Field5) — varchar(50)
  • face (Field6) — varchar(20)

RESERVATION (Untitled9)

  • reservation_id (Key) — bigint — Primary key — NOT NULL
  • member_id (FK) — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • shop_id (PK) — bigint — Foreign key → HAIR_SHOP.shop_id — NOT NULL
  • designer_id (PK2) — bigint — Foreign key → DESIGNER.designer_id — NOT NULL
  • date_time (Field) — datetime
  • status (Field2) — varchar(20)

REVIEW (Untitled4)

  • review_id (PK) — bigint — Primary key — NOT NULL
  • member_id (FK) — bigint — Foreign key → MEMBER.member_id — NOT NULL
  • designer_id (PK2) — bigint — Foreign key → DESIGNER.designer_id — NOT NULL
  • shop_id (PK3) — bigint — Foreign key → HAIR_SHOP.shop_id — NOT NULL
  • rating (Field) — float