ㅇㅁㄴㅇ
Tables (30)
code_list
- code_level — integer — NOT NULL
- is_deleted — boolean — NOT NULL
- order_no — integer — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- updated_at — timestamp(6)
- code — varchar(20) — NOT NULL
- detail_code — varchar(20) — NOT NULL
- detail_name — varchar(100) — NOT NULL
coupon
- discount_value — integer — NOT NULL
- end_date — date — NOT NULL
- is_deleted — boolean — NOT NULL
- start_date — date — NOT NULL
- created_at — timestamp(6)
- updated_at — timestamp(6)
- discount_type — varchar(100) — NOT NULL
- discount_type_detail — varchar(100) — NOT NULL
- type — varchar(100) — NOT NULL
- type_detail — varchar(100) — NOT NULL
- code — varchar(255) — NOT NULL
- title — varchar(255) — NOT NULL
- file_id — bigint
- url — varchar(255)
coupon_category
- id — bigserial
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- coupon_code — varchar(255)
- product_category_id — bigint
coupon_product
- id — bigserial
- created_at — timestamp(6)
- is_deleted — boolean — NOT NULL
- updated_at — timestamp(6)
- coupon_code — varchar(255)
- product_id — bigint
event
- is_deleted — boolean — NOT NULL
- is_main — boolean — NOT NULL
- created_at — timestamp(6)
- end_at — timestamp(6)
- id — bigserial
- start_at — timestamp(6)
- updated_at — timestamp(6)
- status — varchar(100) — NOT NULL
- status_detail — varchar(100) — NOT NULL
- url — varchar(500)
- content — varchar(2000)
- hashtag — varchar(255)
- title — varchar(255) — NOT NULL
- file_id — bigint
- main_order — bigint
file_upload
- is_deleted — boolean — NOT NULL
- created_at — timestamp(6)
- idx — bigserial
- updated_at — timestamp(6)
- category — varchar(10) — NOT NULL
- file_name — varchar(255) — NOT NULL
- origin_name — varchar(255) — NOT NULL
- url — varchar(255)
notice
- is_deleted — boolean — NOT NULL
- created_at — timestamp(6)
- file_id — bigint
- id — bigserial
- updated_at — timestamp(6)
- url — varchar(500)
- content — varchar(2000) — NOT NULL
- title — varchar(255) — NOT NULL
notification
- is_deleted — boolean — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- order_id — bigint
- updated_at — timestamp(6)
- user_id — bigint
- type — varchar(100) — NOT NULL
- type_detail — varchar(100) — NOT NULL
- store_name — varchar(255) — NOT NULL
- content — varchar(255)
- is_read — boolean
order_option
- is_deleted — boolean — NOT NULL
- price — integer — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- order_product_id — bigint
- updated_at — timestamp(6)
- option — varchar(100) — NOT NULL
- option_detail — varchar(100) — NOT NULL
order_product
- is_deleted — boolean — NOT NULL
- qty — integer — NOT NULL
- seq_no — integer — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- order_id — bigint
- product_id — bigint
- updated_at — timestamp(6)
order_status
- is_deleted — boolean — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- order_id — bigint
- updated_at — timestamp(6)
- status — varchar(100) — NOT NULL
- status_detail — varchar(100) — NOT NULL
orders
- is_deleted — boolean — NOT NULL
- is_pick_up — boolean — NOT NULL
- is_take_out — boolean — NOT NULL
- created_at — timestamp(6)
- expect_completed_at — timestamp(6)
- id — bigserial
- store_id — bigint
- updated_at — timestamp(6)
- user_coupon_id — bigint
- user_id — bigint
- order_no — varchar(100) — NOT NULL
- request_msg — varchar(100)
payment
- amount — integer — NOT NULL
- is_deleted — boolean — NOT NULL
- approval_date_time — timestamp(6) — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- order_id — bigint
- updated_at — timestamp(6)
- status — varchar(100) — NOT NULL
- status_detail — varchar(100) — NOT NULL
- approval_number — varchar(255) — NOT NULL
- mid — varchar(255) — NOT NULL
- payment_uid — varchar(255) — NOT NULL
- tid — varchar(255) — NOT NULL
product
- is_deleted — boolean — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- product_category_id — bigint
- updated_at — timestamp(6)
- content — varchar(500)
- url — varchar(500)
- name — varchar(255) — NOT NULL
- name_eng — varchar(255)
- file_id — bigint
product_category
- is_deleted — boolean — NOT NULL
- order_no — integer — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- updated_at — timestamp(6)
- category_name — varchar(50) — NOT NULL
- category_desc — varchar(300) — NOT NULL
- upper_category_code — varchar(255)
- upper_category_detail_code — varchar(255)
product_new
- is_deleted — boolean — NOT NULL
- order_no — integer — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- product_id — bigint
- updated_at — timestamp(6)
product_option
- is_deleted — boolean — NOT NULL
- order_no — integer — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- product_id — bigint
- updated_at — timestamp(6)
- option_code — varchar(100) — NOT NULL
- option_detail — varchar(100) — NOT NULL
product_option_desc
- is_deleted — boolean — NOT NULL
- option_level — integer — NOT NULL
- order_no — integer — NOT NULL
- price — integer — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- updated_at — timestamp(6)
- detail_code — varchar(100) — NOT NULL
- option_code — varchar(100) — NOT NULL
- option_name — varchar(100) — NOT NULL
product_price
- is_deleted — boolean — NOT NULL
- order_no — integer — NOT NULL
- price — integer — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- product_id — bigint
- updated_at — timestamp(6)
- price_code — varchar(100) — NOT NULL
- price_detail — varchar(100) — NOT NULL
- price_name — varchar(255)
product_recommend
- is_deleted — boolean — NOT NULL
- order_no — integer — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- product_id — bigint
- updated_at — timestamp(6)
schedule
- id — bigserial
- event_name — varchar(255) — NOT NULL
- event_time — integer — NOT NULL
stamp
- expiration_at — date — NOT NULL
- is_deleted — boolean — NOT NULL
- stamp_count — integer — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- store_id — bigint
- updated_at — timestamp(6)
- user_id — bigint — NOT NULL
- stamp_code — varchar(100) — NOT NULL
- stamp_detail_code — varchar(100) — NOT NULL
- canceled_at — date
stat
- is_deleted — boolean — NOT NULL
- qty — integer — NOT NULL
- total_price — integer — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- product_id — bigint
- store_id — bigint
- updated_at — timestamp(6)
store
- is_deleted — boolean — NOT NULL
- latitude — real — NOT NULL
- longitude — real — NOT NULL
- created_at — timestamp(6)
- deleted_at — timestamp(6)
- id — bigserial
- updated_at — timestamp(6)
- user_id — bigint — NOT NULL
- representative_name — varchar(20) — NOT NULL
- business_number — varchar(100) — NOT NULL
- name — varchar(100) — NOT NULL
- url — varchar(500)
- address — varchar(255) — NOT NULL
- address_detail — varchar(255) — NOT NULL
- contact_number — varchar(255) — NOT NULL
- mid — varchar(255) — NOT NULL
- is_parking — boolean
- is_smoking — boolean
- is_toilet — boolean
- is_wifi — boolean
- is_open — boolean
store_product
- is_deleted — boolean — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- product_id — bigint
- store_id — bigint
- updated_at — timestamp(6)
- status — varchar(100) — NOT NULL
- status_detail — varchar(100) — NOT NULL
store_time
- close_time — time(6)
- days — integer — NOT NULL
- is_deleted — boolean — NOT NULL
- open_time — time(6)
- created_at — timestamp(6)
- id — bigserial
- store_id — bigint
- updated_at — timestamp(6)
terms
- is_deleted — boolean — NOT NULL
- personal_information_processing — boolean — NOT NULL
- terms_of_use — boolean — NOT NULL
- unique_identification_information_processing — boolean — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- updated_at — timestamp(6)
- user_id — bigint — NOT NULL
user_coupon
- expiration_date — date — NOT NULL
- is_deleted — boolean — NOT NULL
- is_used — boolean — NOT NULL
- issuing_date — date — NOT NULL
- created_at — timestamp(6)
- id — bigserial
- updated_at — timestamp(6)
- user_id — bigint
- code — varchar(255)
user_permission
- is_deleted — boolean — NOT NULL
- is_enable_email — boolean — NOT NULL
- is_enable_location — boolean — NOT NULL
- created_at — timestamp(6)
- updated_at — timestamp(6)
- user_id — bigint — NOT NULL
- is_enable_marketing — boolean
- is_enable_push — boolean
- is_enable_sms — boolean
users
- birthday — date
- is_deleted — boolean — NOT NULL
- stamp_count — integer
- type — integer
- created_at — timestamp(6)
- deleted_at — timestamp(6)
- id — bigserial
- updated_at — timestamp(6)
- nick_name — varchar(10)
- name — varchar(20)
- gender — varchar(100)
- email — varchar(400)
- login_id — varchar(400) — NOT NULL
- address — varchar(255)
- address_detail — varchar(255)
- di — varchar(255)
- fcm — varchar(255)
- mobile_number — varchar(255)
- password — varchar(255) — NOT NULL
- role — varchar(255) — NOT NULL
- ROLE_ADMIN::character — varying
- ROLE_STORE::character — varying)::text))