LIsten to me

Tables (11)

Bookmark (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • counselor_email (Key2) — varchar(100) — Foreign key → Counselor.email — NOT NULL
  • client_email (Key3) — varchar(100) — Foreign key → Client.email — NOT NULL

Career (Untitled10)

  • id (Key) — int — Primary key — NOT NULL
  • email (Key2) — varchar(100) — Foreign key → Counselor.email — NOT NULL
  • name (Field) — varchar(45)

Category (Untitled11)

  • id (Key) — int — Primary key — NOT NULL
  • category (Field) — varchar(45)

Certificate (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • email (Key2) — varchar(100) — Foreign key → Counselor.email — NOT NULL
  • name (Field2) — varchar(45)

Client (Untitled14)

  • email (Key) — varchar(100) — Foreign key → User.email — NOT NULL
  • nickname (Field) — varchar(100)

Counselor (Untitled15)

  • email (Key) — varchar(100) — Foreign key → User.email — NOT NULL
  • photo (Field) — varchar(45)
  • greeting (Field2) — varchar(200)
  • degree (Field3) — varchar(100)

Counselor_category (Untitled12)

  • id (Key2) — int — Primary key — NOT NULL
  • email (Key3) — varchar(100) — Foreign key → Counselor.email — NOT NULL
  • id (Key) — int — Foreign key → Category.id — NOT NULL

Memo (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • schedule_id (Key2) — int — Foreign key → Schedule.id — NOT NULL
  • user_email (Field) — varchar(45)
  • title (Field2) — varchar(45)
  • content (Field3) — varchar(500)

Review (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • counselor_email (Key2) — varchar(100) — Foreign key → Counselor.email — NOT NULL
  • client_email (Key3) — varchar(100) — Foreign key → Client.email — NOT NULL
  • star_score (Field) — int
  • content (Field2) — varchar(100)

Schedule (Untitled9)

  • id (Key) — int — Primary key — NOT NULL
  • counselor_email (Key2) — varchar(100) — Foreign key → Counselor.email — NOT NULL
  • client_email (Key3) — varchar(100) — Foreign key → Client.email — NOT NULL
  • date (Field) — Date
  • topic (Field2) — varchar(45)
  • point (Field3) — int
  • state (Field6) — int

User (Untitled13)

  • email (Key) — varchar(100) — Primary key — NOT NULL
  • password (Field) — varchar(200)
  • name (Field2) — varchar(45)
  • gender (Field3) — char(10)
  • birth (Field4) — Date
  • point (Field5) — int
  • phone_number (Field6) — varchar(255)
  • dtype (Field7) — varchar(31)