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