ㅇㅁㄴㅇ

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))