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)