soomgo
Tables (18)
Member (Untitled5)
Post
- post_id — int — Primary key — NOT NULL
- content — text — NOT NULL
- author_name — string — NOT NULL
- liked — int — NOT NULL
- view — int — NOT NULL
- comment_count — int — NOT NULL
- date_created — datetime — NOT NULL
- date_updated — datetime — NOT NULL
- region — string — NOT NULL
- title — string — NOT NULL
- category_id (Key) — int — Foreign key → category.id — NOT NULL
- admin_id — int — Foreign key → admin.admin_id — NOT NULL
- author_id (id2) — varchar(20) — Foreign key → User.id — NOT NULL — 시스템에서 구분하는 id
- author_id (id3) — varchar(20) — Foreign key → expert.id — NOT NULL
User (user)
- id — varchar(20) — Primary key — NOT NULL — 시스템에서 구분하는 id
- password — varchar(20) — NOT NULL
- date_created — datetime — NOT NULL
- phone — string — NOT NULL
- region — string — NOT NULL
- username — string — NOT NULL
- payment_id — int — Foreign key → payment.id — NOT NULL
admin
- admin_id — int — Primary key — NOT NULL
- email — varchar(20)
- password — varchar(20)
category (Untitled)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — string — NOT NULL
- community_id (id) — int — Foreign key → commnunity.id — NOT NULL
- Field2
chatroom (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- expert_id (id) — varchar(20) — Foreign key → expert.id — NOT NULL
- user_id (id2) — varchar(20) — Foreign key → User.id — NOT NULL — 시스템에서 구분하는 id
comment
- comment_id — int — Primary key — NOT NULL
- liked — int — NOT NULL
- author_id — int — NOT NULL
- post_id — int — Foreign key → Post.post_id — NOT NULL
- username — string — NOT NULL
commnunity (community)
- id — int — Primary key — NOT NULL
- name — string — NOT NULL
expert
- id — varchar(20) — Primary key — NOT NULL
- password — varchar(20) — NOT NULL
- rate — float — NOT NULL
- name — string — NOT NULL
- phone — string — NOT NULL
- date_created — datetime — NOT NULL
- region — string — NOT NULL
- email — varchar(20) — NOT NULL
- category — string — NOT NULL
- username — string — NOT NULL
know-how (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- username (Field2) — string — NOT NULL
- contnet (Field3) — text — NOT NULL
- title (Field4) — string — NOT NULL
- community_id (id) — int — Foreign key → commnunity.id — NOT NULL
- admin_id — int — Foreign key → admin.admin_id — NOT NULL
- writer_id (id2) — varchar(20) — Foreign key → expert.id — NOT NULL
lecture
- lect_id — int — Primary key — NOT NULL
- title — string — NOT NULL
- content — text — NOT NULL
- region — string — NOT NULL
- expert_name — string — NOT NULL
- expert_id (id2) — varchar(20) — Foreign key → expert.id — NOT NULL
message
- message_id — int — Primary key — NOT NULL
- sender_id — int — NOT NULL
- rading_status — boolean — NOT NULL
- content — text — NOT NULL
- chatroom_id (Key) — int — Foreign key → chatroom.id — NOT NULL
payment
- id (payment_id) — int — Primary key — NOT NULL
- date_created — datetime — NOT NULL
- payment_method — varchar(20) — NOT NULL
- price — int — NOT NULL
- date_updated — datetime — NOT NULL
- payment_date — datetime — NOT NULL
- user_id — int — NOT NULL
- service_id — int — NOT NULL
portfolio
- portfolio_id — int — Primary key — NOT NULL
- picture — blob — NOT NULL
- content — text — NOT NULL
- expert_id — varchar(20) — Foreign key → expert.id — NOT NULL
profile (Untitled3)
- id (Key2) — int — Primary key — NOT NULL
- service_id (Key) — int — Foreign key → service.id — NOT NULL
- expert_name (Field) — string — NOT NULL
- rating (Field2) — float — NOT NULL
- introduce (Field3) — varchar(255) — NOT NULL
- review_count (Field4) — int — NOT NULL
- expert_id (id) — varchar(20) — Foreign key → expert.id — NOT NULL
quotation
- quote_id — int — Primary key — NOT NULL
- price — integer — NOT NULL
- adoption — boolean — NOT NULL
- content — text — NOT NULL
- period — datetime — NOT NULL
- id (id2) — varchar(20) — Foreign key → User.id — NOT NULL — 시스템에서 구분하는 id
review
- review_id — int — Primary key — NOT NULL
- rate — float — Primary key
- content — text
- date_created — datetime — NOT NULL
- date_updated — datetime — NOT NULL
- picture — blob
- author_id (id2) — varchar(20) — Foreign key → User.id — NOT NULL — 시스템에서 구분하는 id
- expert_id (id3) — varchar(20) — Foreign key → expert.id — NOT NULL
service
- id (Key) — int — Primary key — NOT NULL
- review_count — int — NOT NULL
- expert_count — int — NOT NULL
- category — string — NOT NULL
- request_count — int — NOT NULL
- content — text — NOT NULL
- service_name — string — NOT NULL