04note3
Tables (13)
address
- address_code — varchar(255) — NOT NULL
- sido — varchar(255)
- sigungu — varchar(255)
- eubmyeondong — varchar(255)
building
- building_id — bigint
- address — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- customer_id — bigint — NOT NULL
construction
- construction_id — bigint
- user_id — varchar(255)
- kind — varchar(255) — NOT NULL
- time_begin — date — NOT NULL
- time_end — date
- city — varchar(255) — NOT NULL
- district — varchar(255) — NOT NULL
- dong — varchar(255) — NOT NULL
- work_site_description — varchar(255)
- memo — varchar(255)
- charge — bigint
- created_at — datetime(6)
- expense — bigint
- is_received — bit — NOT NULL
- customer_id — bigint
customer
- customer_id — bigint
- name — varchar(255) — NOT NULL
- phone_number — varchar(255) — NOT NULL
- special_notes — varchar(255)
- user_id — varchar(255) — NOT NULL
hiring_post_apply
- hiring_post_apply_id — bigint
- user_id — varchar(255)
- hiring_post_id — bigint
- is_hired — bit — NOT NULL
- created_at — datetime(6)
post
- post_id — bigint
- user_id — varchar(255)
- address_code — varchar(255)
- title — varchar(255)
- content — varchar(255)
- pay — int
- created_at — datetime(6)
- deleted — bit — NOT NULL
- date — date
- level — varchar(255)
- state — bit — NOT NULL
post_like
- post_like_id — bigint
- user_id — varchar(255)
- post_id — bigint
- created_at — datetime(6)
- deleted — bit — NOT NULL
post_skill
- post_skill_id — int
- post_id — bigint
- skill_id — int
review
- review_id — bigint
- reviewer_id — varchar(255)
- reviewee_id — varchar(255)
- post_id — bigint
- content — varchar(255)
- rate — int — NOT NULL
- created_at — datetime(6)
- deleted — bit — NOT NULL
review_keywords
- review_id — bigint — NOT NULL
- keyword — enum
skill
- skill_id — int
- name — varchar(255) — NOT NULL
user
- user_id — varchar(255) — NOT NULL
- address_code — varchar(255)
- nickname — varchar(255)
- level — varchar(255)
- rate — double
user_skill
- user_skill_id — int
- user_id — varchar(255)
- skill_id — int