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